Python Forum
Converting raw data into panel data
Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Converting raw data into panel data
#1
I have a problem about converting raw data into panel data.
I got the following data in excel like:
Name MMMmarketcap MMMstoctprice APPLmarketcap APPLstoctprice ... (i)marketcap (i)stockprice
01/2001 a1 b1 c1 d1
.... ... ... ... ...
05/2018 an bn ... ...
How can I convert the data into panel format like:
Date Name MarketCap Stock Price
01/2001 MMM a1 b1
....
05/2018
01/2001 AAPL c1 d1
....
05/2018
I try but i cannot get the result expected :
df1 = pd.melt(df,id_vars=["Name"])
I got something like:
Name Variable Value
01/2001 MMMmarketcap a1
....
05/2018 MMMmarketcap an
01/2011 MMMstockprice b1
....
05/2018 MMM stockprice bn

Many thanks for helping.
Reply


Messages In This Thread
Converting raw data into panel data - by jason413 - May-25-2018, 03:48 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Help with to check an Input list data with a data read from an external source sacharyya 3 400 Mar-09-2024, 12:33 PM
Last Post: Pedroski55
  Write sql data or CSV Data into parquet file mg24 2 2,410 Sep-26-2022, 08:21 AM
Last Post: ibreeden
  Load multiple Jason data in one Data Frame vijays3 6 1,536 Aug-12-2022, 05:17 PM
Last Post: vijays3
  Issue in changing data format (2 bytes) into a 16 bit data. GiggsB 11 2,644 Jul-25-2022, 03:19 PM
Last Post: deanhystad
  Adding shifted data set to data set xquad 3 1,495 Dec-22-2021, 10:20 AM
Last Post: Larz60+
  Converting data object mbrown009 5 2,769 May-30-2021, 11:35 PM
Last Post: mbrown009
  Looking for data/info on a perticular data-proccesing problem. MvGulik 9 3,846 May-01-2021, 07:43 AM
Last Post: MvGulik
  How to filter out Column data From Multiple rows data? firaki12345 10 5,090 Feb-06-2021, 04:54 AM
Last Post: buran
  how to print all data from all data array? korenron 3 2,455 Dec-30-2020, 01:54 PM
Last Post: korenron
  Converting data in CSV and TXT to dictionary kam_uk 3 1,979 Dec-22-2020, 08:43 PM
Last Post: bowlofred

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020