Python transpose data set

Question

Looking for a python script to do this. The below only is only a sample and values are for CPU consumption in seconds.

I have a CSV in the format:

col1    col2   col3    col4  Apr2018   May2018   June2018   July 2018 
-----------------------------------------------------------------
Job1    ABD    dt.com  BU1   45087     67547      876465    987564
Job2    ACS    pl.com  BU2   94768     87658      987689    97678

Now I want to be able to get like this in a dataframe/ Table 

col1    col2   col3    col4  Date      Value
---------------------------------------------
Job1    ABD    dt.com  BU1   Apr2018    45087     
Job1    ABD    dt.com  BU1   May2018    67547
Job1    ABD    dt.com  BU1   June2018   876465
Job1    ABD    dt.com  BU1   July2018   987564

Job2    ACS    pl.com  BU2   Apr2018     94768       
Job2    ACS    pl.com  BU2   May2018     87658
Job2    ACS    pl.com  BU2   June2018    987689
Job2    ACS    pl.com  BU2   July2018      97678

Please take a look at https://pandas.pydata.org/pandas-docs/version/0.23.4/generated/pandas.melt.html — godimedia, Oct 30 '18 at 04:16

Karthick Aravindan · Answer 1 · 2019-05-02T11:11:32.417

0

   import pandas as pd
   df=pd.read_csv("csv file")
   convert_df = pd.melt(df, id_vars=["col1","col2","col3,"col4"], 
                  var_name="Date", value_name="Value")
   convert_df = convert_df.sort(["col1","col2","col3,"col4"])
   print(convert_df)

there is function melt in pandas dataframe.

edited May 02 '19 at 11:11

answered Oct 30 '18 at 04:32

Karthick Aravindan

1,042
3
12
19

Thanks so much Karthick, worked very well.. – chandana Oct 30 '18 at 05:18

Python transpose data set

1 Answers1