How to convert time column to Unix timestamp?

Question

I would like to convert Datetime column to Epoch / Unix timestamp.

import pandas as pd
import yfinance as yf
import numpy as np
import time
df = yf.download(tickers='^NSEI',period='1d',interval='15m')
df.reset_index(inplace=True)
df.rename(columns = {'Datetime':'time'}, inplace = True)
df['Date'] = df['time'].dt.strftime('%Y-%m-%d')
df['time'] = df['time'].dt.strftime("%Y-%m-%d %H:%M:%S") 
df

@balderman i have updated code and image is for Columns reference — Yash
– Yash, Commented Oct 3, 2021 at 9:18
What is the problem? What did you try and how it failed? Where are the import statements ? How can we reproduce your code without it? — balderman
– balderman, Commented Oct 3, 2021 at 9:19
Does this answer your question? Converting to unix timestamp Python — Shireen
– Shireen, Commented Oct 3, 2021 at 9:23

Mark Rotteveel · Accepted Answer · 2021-10-03 09:31:29Z

1

Use this provide function citation

def utctimestamp(ts: str, DATETIME_FORMAT: str = "%d/%m/%Y"):
    import datetime, calendar
    ts = datetime.datetime.utcnow() if ts is None else datetime.datetime.strptime(ts, DATETIME_FORMAT)
    return calendar.timegm(ts.utctimetuple())

Example code (not tested)

# Imports
import datetime, calendar

# custom function
def utctimestamp(ts: str, DATETIME_FORMAT: str = "%d/%m/%Y %H:%M:%S"):
    ts = datetime.datetime.utcnow() if ts is None else datetime.datetime.strptime(ts, DATETIME_FORMAT)
    return calendar.timegm(ts.utctimetuple())

# updated code
df = yf.download(tickers='^NSEI',period='1d',interval='15m')
df.reset_index(inplace=True)
df.rename(columns = {'Datetime':'time'}, inplace = True)
df['Date'] = df['time'].dt.strftime('%Y-%m-%d')
df['time'] = utctimestamp(df['time'].dt.strftime("%Y/%m/%d %H:%M:%S"))

edited Oct 3, 2021 at 9:31

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Oct 3, 2021 at 9:21

X3R0

6,4152 gold badges19 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yash Over a year ago

it works when i enter single row value but not apply for all see image 1 ibb.co/myPb0ks and image 2 ibb.co/2ckFxNC as you can see when i am calling series its not working any fix for it?

Collectives™ on Stack Overflow

How to convert time column to Unix timestamp?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related