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
#1
Hi,
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??
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help: Conversion of Electricity Data into Time Series Data SmallGuy 3 1,155 Oct-04-2023, 03:31 PM
Last Post: deanhystad
  Time Series Production Process Problem Mzarour 1 2,096 Feb-28-2023, 12:25 PM
Last Post: get2sid
  Make unique id in vectorized way based on text data column with similarity scoring ill8 0 861 Dec-12-2022, 03:22 AM
Last Post: ill8
  reduce time series based on sum condition amdi40 0 1,078 Apr-06-2022, 09:09 AM
Last Post: amdi40
  How to accumulate volume of time series amdi40 3 2,259 Feb-15-2022, 02:23 PM
Last Post: amdi40
  What if a column has about 90% of data as outliers? Asahavey17 1 1,781 Aug-23-2021, 04:55 PM
Last Post: jefsummers
  Pandas Data frame column condition check based on length of the value aditi06 1 2,655 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Adding a new column to a Panda Data Frame rsherry8 2 2,082 Jun-06-2021, 06:49 PM
Last Post: jefsummers
  How to convert time to sec in boucle for cencen 1 1,873 Apr-17-2021, 05:42 PM
Last Post: cencen
  Recommendations for ML libraries for time-series forecast AndreasPython 0 1,862 Jan-06-2021, 01:03 PM
Last Post: AndreasPython

Forum Jump:

User Panel Messages

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