Skip to content

Instantly share code, notes, and snippets.

@amankharwal
Created November 12, 2020 06:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amankharwal/7fede707332f9f99647d4c485963b2a3 to your computer and use it in GitHub Desktop.
Save amankharwal/7fede707332f9f99647d4c485963b2a3 to your computer and use it in GitHub Desktop.
import datetime
import time
timestamp = []
for d, t in zip(data['Date'], data['Time']):
try:
ts = datetime.datetime.strptime(d+' '+t, '%m/%d/%Y %H:%M:%S')
timestamp.append(time.mktime(ts.timetuple()))
except ValueError:
# print('ValueError')
timestamp.append('ValueError')
timeStamp = pd.Series(timestamp)
data['Timestamp'] = timeStamp.values
final_data = data.drop(['Date', 'Time'], axis=1)
final_data = final_data[final_data.Timestamp != 'ValueError']
final_data.head()
@Mohsin81
Copy link

"OverflowError: mktime argument out of range" Any way there's a fix?

@Satyam-Nayak
Copy link

OverflowError Traceback (most recent call last)
~\AppData\Local\Temp\ipykernel_1584\2811706222.py in
6 try:
7 ts = datetime.datetime.strptime(d+' '+t, '%m/%d/%Y %H:%M:%S')
----> 8 timestamp.append(time.mktime(ts.timetuple()))
9 except ValueError:
10 # print('ValueError')

OverflowError: mktime argument out of range

Any way there's a fix?

@mengmeng0124
Copy link

"OverflowError: mktime argument out of range" Any way there's a fix?

delete “csv” “date” before 1971

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment