Pandas Python DataFrame format conversion

Question

1 Pandas DF is available in this format but I want to convert in another format which is image 2.

Please provide any idea about how can i convert.

see dupe - also have a read of [mcve] and [ask] images are not acceptable for examples on stackoverflow. — Umar.H, Dec 21 '21 at 13:02

Corralien · Accepted Answer · 2021-12-21T13:09:41.210

1

Use pd.melt:

out = df.melt(['DateTime', 'Machine'], var_name='Variable', value_name='Value') \
        .sort_values('DateTime', ascending=False).reset_index(drop=True)
print(out)

# Output:
              DateTime Machine     Variable  Value
0  2021-02-01 09:26:00      GE  Temperature     30
1  2021-02-01 09:26:00      GE        Speed   1200
2  2021-02-01 09:25:00      GE  Temperature     32
3  2021-02-01 09:25:00      GE        Speed   1200
4  2021-02-01 09:24:00      GE  Temperature     35
5  2021-02-01 09:24:00      GE        Speed   1200
6  2021-02-01 09:23:00      GE  Temperature     26
7  2021-02-01 09:23:00      GE        Speed   1200
8  2021-02-01 09:22:00      GE  Temperature     31
9  2021-02-01 09:22:00      GE        Speed   1200
10 2021-02-01 09:21:00      GE  Temperature     32
11 2021-02-01 09:21:00      GE        Speed   1200
12 2021-02-01 09:20:00      GE  Temperature     35
13 2021-02-01 09:20:00      GE        Speed   1200
14 2021-02-01 09:19:00      GE  Temperature     38
15 2021-02-01 09:19:00      GE        Speed   1200

edited Dec 21 '21 at 13:09

answered Dec 21 '21 at 13:02

Corralien

109,409
8
28
52

Hi, It solves the problem for this DF. But for another DF it shows error: ValueError: Data must be 1-dimensional – Chio Dec 21 '21 at 13:18
You have to update your version of Pandas. What is your version? – Corralien Dec 21 '21 at 13:20
pandas 1.3.5 version – Chio Dec 21 '21 at 13:26
Can you share your data? Do you have columns with the same name? – Corralien Dec 21 '21 at 13:27
I couldn't attach the table.. sorry.. it's with different names and time column.. I changed the column name in the code you sent – Chio Dec 21 '21 at 13:33
1

Or you have a column that contains arrays and not scalar values. – Corralien Dec 21 '21 at 13:35
yes, now I changed to DF using pd.DataFrame(df, columns = [' ']. The code line is working with converting the format but all values are NAN. – Chio Dec 21 '21 at 14:00
1

I mean not in column name. I think you have a column values that contain arrays. – Corralien Dec 21 '21 at 14:02
1

Yeah mate.. it's working now... thanks a lot – Chio Dec 21 '21 at 14:13

Pandas Python DataFrame format conversion

1 Answers1