Guest User

Untitled

a guest
Dec 11th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. s3 = boto3.client('s3', region_name='eu-central-1')
  2. obj = s3.get_object(Bucket='bucket', Key='Data/data.csv')
  3. df1 = pd.read_csv(obj['Body'])
  4. obj = s3.get_object(Bucket='bucket', Key='Data/data.csv')
  5. df2 = pd.read_csv(obj['Body'])
  6. df = pd.concat([df1, df2])
  7.  
  8. # date conversion
  9. df.D_TRANS_DATE = pd.to_datetime(df.D_TRANS_DATE, format='%d.%m.%Y %H:%M:%S')
  10. df['D_TRANS_DATE_YEAR']=df['D_TRANS_DATE'].dt.year
  11. df['D_TRANS_DATE_MONTH']=df['D_TRANS_DATE'].dt.month
Add Comment
Please, Sign In to add comment