python-pandasHow to convert datetime to timestamp

import pandas as pd
import numpy as np

df = pd.DataFrame({
  'date_time_str': ['3/10/2022 14:43:24', '3/11/2022 14:43:24', '3/12/2022 14:43:24'],
  'value': [1,2,3]
})

df['timestamp'] = pd.to_datetime(df['date_time_str']).values.astype(np.int64) // 10 ** 9ctrl + cgithub

`import pandas as pd` load Pandas module	`pd.DataFrame` creates Pandas DataFrame object
`.to_datetime(` convert given column values to datetime type (will automatically parse given strings)	`date_time_str` string column with date & time
`'timestamp'` column will contain timestamp	`import numpy as np` load Numpy module for Python
`.values.astype(np.int64)` converts datetime to int to get timestamp

Usage example

import pandas as pd
import numpy as np

df = pd.DataFrame({
  'date_time_str': ['3/10/2022 14:43:24', '3/11/2022 14:43:24', '3/12/2022 14:43:24'],
  'value': [1,2,3]
})

df['timestamp'] = pd.to_datetime(df['date_time_str']).values.astype(np.int64) // 10 ** 9
print(df)

output

        date_time_str  value   timestamp
0  3/10/2022 14:43:24      1  1646923404
1  3/11/2022 14:43:24      2  1647009804
2  3/12/2022 14:43:24      3  1647096204

More of Python Pandas

See more codes...

python-pandasHow to convert datetime to timestamp

Usage example

output

Related

More of Python Pandas