Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dataset = pd.read_csv('n.csv')
- data= pd.DataFrame(dataset,columns= ['date','time','temperature','humidity','wind'])
- data['time'] = pd.to_timedelta(data['time'])
- data['time'] -= data.at[0, 'time']
- data['time'] = data['time'].dt.total_seconds()
- data['time']= pd.to_datetime(data['time'], unit='s')
- data = (data.set_index('time')
- .resample('60T').first()
- .reset_index()
- .reindex(columns=data.columns))
- data['time'] = data['time'].astype(np.int64) // 10**9
- print(data)
- date time temperature humidity wind
- 0 10/3/2018 0 63 0 0
- 1 10/3/2018 3600 63 0 2
- 2 10/3/2018 7200 104 11 0
- 3 10/3/2018 10800 93 0 50
- 4 10/3/2018 14400 177 0 2
- 5 10/3/2018 18000 133 0 0
- 6 10/3/2018 21600 70 0 0
- 7 10/4/2018 25200 210 50 20
- 8 10/5/2018 28800 170 20 40
- 9 10/3/2018 32400 127 0 50
- 10 10/3/2018 36000 205 0 0
- 11 10/3/2018 39600 298 0 0
- 12 10/3/2018 43200 234 0 0
- 13 10/3/2018 46800 148 0 20
- 14 10/3/2018 50400 135 0 0
- 15 10/3/2018 54000 100 0 50
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement