Python Forum
How can I convert time-series data in rows into column
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How can I convert time-series data in rows into column
I have a data-set where the information is showing that certain item is sold in different date. The date mentioned in the rows as like below.
item_id item_name m_1 m_2 m_3
 a_1      a         1   2   0
 b_1      b         0   1   1
I need to convert the data into column line below.
item_id item_name month item_sold
a_1       a        m_1      1    
a_1       a        m_2      2    
a_1       a        m_3      0    
b_1       b        m_1      0    
b_1       b        m_2      1    
b_1       b        m_3      1    
Can any one help me please??

Possibly Related Threads…
Thread Author Replies Views Last Post
  how to handling time series data file with Python? aupres 4 403 Aug-10-2020, 12:40 PM
Last Post: MattKahn13
  Extracting rows based on condition on one column Robotguy 2 197 Aug-07-2020, 02:27 AM
Last Post: Robotguy
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 269 Aug-03-2020, 02:05 AM
Last Post: scidam
  How to shift data frame rows of specified column Mekala 0 434 Jul-21-2020, 02:42 PM
Last Post: Mekala
  Changing Time Series from Start to End of Month illmattic 0 328 Jul-16-2020, 10:49 AM
Last Post: illmattic
  Filter data based on a value from another dataframe column and create a file using lo pawanmtm 1 291 Jul-15-2020, 06:20 PM
Last Post: pawanmtm
  HELP- DATA FRAME INTO TIME SERIES- BASIC bntayfur 0 235 Jul-11-2020, 09:04 PM
Last Post: bntayfur
  Assigning Column nunique values to another DataFrame column Pythonito 0 264 Jun-25-2020, 05:04 PM
Last Post: Pythonito
  Filter rows by multiple text conditions in another data frame i.e contains strings an Pan 0 459 Jun-09-2020, 06:05 AM
Last Post: Pan
  Differencing Time series and Inverse after Training donnertrud 0 350 May-27-2020, 06:11 AM
Last Post: donnertrud

Forum Jump:

User Panel Messages

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