Python Forum
how to handling time series data file with Python?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to handling time series data file with Python?
#1
I am a newbie in deep learning and try to make feature matrix with python. My sample data structure is like below,

dataset.csv

State   Earnings   Hispanic   Indian   Asian   Black   White   people_in_poverty

Alabama   0.2        0.4        0.6     0.6      0.2    0.8          a.csv
Florida   0.5        0.6        0.4     0.1      0.6    0.7          b.csv
Kentucky  0.7        0.7        0.9     0.8      0.3    0.6          c.csv
Minnesota 0.3        0.1        0.2     0.5      0.2    0.7          d.csv
....
The column names [Earnings, Hispanic, Indian, Asian, Black, White] are the attributes and people_in_poverty is the class of feature matrix. When the value of people_in_poverty is numeric, the python codes are simple.

people_in_poverty
0.7
0.3
0.2
0.6
import pandas as pd
df = pd.read_csv('dataset.csv', names=['state', 'Earnings', 'Hispanic', 'Indian', 'Asian', 'Black', 'White', 'people_in_poverty'])
dataset = df.values
However, in my case, the class of feature matrix has csv file which includes the times series data.


people_in_poverty
a.csv
b.csv
c.csv
d.csv
a.csv
2010-08-27        0.2
2010-09-27        0.7
2010-10-27        0.6
2010-11-27        0.9
2010-12-27        0.4
2011-01-27        0.8
2011-02-27        0.5
2011-03-27        0.3
Then I want to know how to modify my pd.read_csv() python codes. The class of the feature matrix is not the numeric value, but csv file containing the time series values. Any advice is needed. Thanks in advanced.
Reply


Messages In This Thread
how to handling time series data file with Python? - by aupres - Jul-28-2020, 01:01 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Help: Conversion of Electricity Data into Time Series Data SmallGuy 3 1,213 Oct-04-2023, 03:31 PM
Last Post: deanhystad
  Time Series Production Process Problem Mzarour 1 2,131 Feb-28-2023, 12:25 PM
Last Post: get2sid
  Add data to CSV file via Python Anaconda23 0 721 Dec-30-2022, 02:31 AM
Last Post: Anaconda23
  reduce time series based on sum condition amdi40 0 1,102 Apr-06-2022, 09:09 AM
Last Post: amdi40
  How to accumulate volume of time series amdi40 3 2,307 Feb-15-2022, 02:23 PM
Last Post: amdi40
  Recommendations for ML libraries for time-series forecast AndreasPython 0 1,887 Jan-06-2021, 01:03 PM
Last Post: AndreasPython
  Find two extremum in data series Sancho_Pansa 0 1,690 Dec-04-2020, 02:06 PM
Last Post: Sancho_Pansa
  Time Series forecating with multiple independent variables Krychol88 1 1,866 Oct-23-2020, 08:11 AM
Last Post: DPaul
  Changing Time Series from Start to End of Month illmattic 0 1,867 Jul-16-2020, 10:49 AM
Last Post: illmattic
  HELP- DATA FRAME INTO TIME SERIES- BASIC bntayfur 0 1,756 Jul-11-2020, 09:04 PM
Last Post: bntayfur

Forum Jump:

User Panel Messages

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