Advertisement
BinaryJacob

Date Time convert Pandas

Feb 25th, 2020
599
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.68 KB | None | 0 0
  1. import datetime
  2.     import calendar
  3.     import pandas as pd
  4.     #import snowflake.connector as sf
  5.        
  6.     filepath = 'MOODY_FILE.csv'
  7.     id_vars = ["Mnemonic"," Concept"," Geography"," Description"," Last Updated", " Native Frequency", " Historical End Date"]
  8.        
  9.     df = pd.read_csv(filepath, delimiter=",")
  10.     df1 = pd.melt(df, id_vars , var_name= 'PERIOD_END_DATE', value_name="MNEMONIC_VALUE")
  11.     print(df1)  
  12.     vk=df1["PERIOD_END_DATE"]  
  13.     vkdate = pd.to_datetime(vk, format='%b-%y').date()
  14.     ldays=calendar.monthrange(vkdate.year, vkdate.month)[-1]
  15.     vkdate_new=datetime.date(int(vkdate.year), int(vkdate.month), int(ldays))
  16.     print(vk)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement