Question

How to create the timestamp object with pandas in Python

Answer 1

import pandas as pd 
  
ts = pd.Timestamp(year = 2020,  month = 5, day = 15, 
                  hour = 13, minute = 32, second = 20, tz = 'US/Central') 
  
print(ts) 
  
  
  
'''
run:
  
2020-05-15 13:32:20-05:00
      

 

70+ SQL courses for beginners and professionals

Answer 2

import pandas as pd 
  
ts = pd.Timestamp('2020-05-15T17:08') 
  
print(ts) 
  
  
  
'''
run:
  
2020-05-15 17:08:00
                
'''

 

70+ SQL courses for beginners and professionals

Answer 3

import pandas as pd 
  
ts = pd.Timestamp(1679899365.5, unit='s') 
  
print(ts) 
  
  
  
'''
run:
  
2023-03-27 06:42:45.500000
                
'''

 

70+ SQL courses for beginners and professionals

Answer 4

import pandas as pd 
  
ts = pd.Timestamp(1679899365.5, unit='s', tz='US/Pacific') 
  
print(ts) 
  
  
  
'''
run:
  
2023-03-26 23:42:45.500000-07:00
                
'''

 

70+ SQL courses for beginners and professionals