Converting python dataframe into proper row column format

Question

I have dataframe like this

field_id    field_name       field_value
4           Rate                  40
5           Rate                  35
4           Duration              60
5           Duration              180

I want to convert it into something like this

id    Rate        Duration
4       40           60
5       35           180

How can I do this in python ? Please help

You may post a snapshot (copy snapshot and paste in the editor) or explore the editor for better formatting your input — JALO - JusAnotherLivngOrganism, Jun 29 '20 at 08:00
Does this answer your question? [Python Pandas: Convert Rows as Column headers](https://stackoverflow.com/questions/17298313/python-pandas-convert-rows-as-column-headers) — JALO - JusAnotherLivngOrganism, Jun 29 '20 at 08:04
@JALO-JusAnotherLivngOrganism In the example that you mentioned, I want to make country values as column names(Afghanistan , Algeria etc), medal and no. of medals as its values. That is what I am trying to do — dev-shp, Jun 29 '20 at 08:11

Bernad Peter · Answer 1 · 2020-06-29T08:56:23.487

0

You can use pivot tables function

print(df)
field_id    field_name  field_value
0   4   Rate    40
1   5   Rate    35
2   4   Duration    60
3   5   Duration    180

df['field_value']=df['field_value'].astype('int64')
df1=df.pivot_table(index='field_id',columns='field_name',values='field_value')
df1
#output: 
field_name  Duration    Rate
field_id        
4   60  40
5   180 35

edited Jun 29 '20 at 08:56

answered Jun 29 '20 at 08:12

Bernad Peter

504
5
12

I am getting this error DataError: No numeric types to aggregate – dev-shp Jun 29 '20 at 08:20
make sure your column dtype is int64 for the filed_value column. if not use use astype to convert to int format. – Bernad Peter Jun 29 '20 at 08:25
field_name and field_value is of type object right now and field_id is int64 – dev-shp Jun 29 '20 at 08:44
use this command to change to numeric: see the updated code – Bernad Peter Jun 29 '20 at 08:55
@ BernadPeter I am getting this ValueError: invalid literal for int() with base 10: '0.0' – dev-shp Jun 29 '20 at 09:16
it is difficult to understand your problem without looking into the full dataframe info and dtypes – Bernad Peter Jun 29 '20 at 09:28
@ BernadPeter okay.. Will let you know all the information – dev-shp Jun 29 '20 at 09:43

Converting python dataframe into proper row column format

1 Answers1