0

I have this CSV

day        time       dni_tilt  d_tilt    r  g_tilted  dni  dhi  ghi  sky  top  code
                                                                       
2020-08-25 00:15       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 00:30       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 00:45       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 01:00       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 01:15       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
...                    ...     ...  ...       ...  ...  ...  ...  ...  ...   ...
2020-08-25 23:00       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 23:15       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 23:30       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 23:45       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 24:00       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1

I need to read it back as a DataFrame like this:

                     dni_tilt  d_tilt    r  g_tilted  dni  dhi  ghi  sky  top  code
                                                                       
2020-08-25 00:15       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 00:30       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 00:45       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1

that is the first column must be a data-time index. I tried with:

 colnames =['day','time','dni_tilt' ,'d_tilt','r','g_tilted', 'dni', 'dhi','ghi','sky','top','code'] 
 out=pd.read_csv(
                response_buffer,                     
                delimiter=' ',
                index_col=0,
                header=None,               
                names=colnames, 
                infer_datetime_format=True,
                parse_dates=[['day','time']])

but the result is strange:

                       dni_tilt  d_tilt    r  g_tilted  dni  dhi  ghi  sky  top  code
day_time                                                                        
2020-08-25 00:15       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 00:30       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 00:45       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 01:00       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 01:15       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
...                    ...     ...  ...       ...  ...  ...  ...  ...  ...   ...
2020-08-25 23:00       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 23:15       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 23:30       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 23:45       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
2020-08-25 24:00       0.0     0.0  0.0       0.0  0.0  0.0  0.0  0.0  0.0     1
gdm
  • 7,647
  • 3
  • 41
  • 71

0 Answers0