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
#2
why are you running subject words together? It's annoying and not necessary
Reply


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 317 Mar-09-2024, 12:33 PM
Last Post: Pedroski55
  Write sql data or CSV Data into parquet file mg24 2 2,356 Sep-26-2022, 08:21 AM
Last Post: ibreeden
  Load multiple Jason data in one Data Frame vijays3 6 1,500 Aug-12-2022, 05:17 PM
Last Post: vijays3
  Issue in changing data format (2 bytes) into a 16 bit data. GiggsB 11 2,560 Jul-25-2022, 03:19 PM
Last Post: deanhystad
  Adding shifted data set to data set xquad 3 1,471 Dec-22-2021, 10:20 AM
Last Post: Larz60+
  Converting data object mbrown009 5 2,718 May-30-2021, 11:35 PM
Last Post: mbrown009
  Looking for data/info on a perticular data-proccesing problem. MvGulik 9 3,780 May-01-2021, 07:43 AM
Last Post: MvGulik
  How to filter out Column data From Multiple rows data? firaki12345 10 5,010 Feb-06-2021, 04:54 AM
Last Post: buran
  how to print all data from all data array? korenron 3 2,423 Dec-30-2020, 01:54 PM
Last Post: korenron
  Converting data in CSV and TXT to dictionary kam_uk 3 1,951 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