/Python/To extract out only year month from a date column in pandas

To extract out only year month from a date column in pandas

Extract year from datetime pandas

df['date'] = pd.to_datetime(df['date'],format='%Y%m%d')
df['year'] = pd.DatetimeIndex(df['date']).year
df['month'] = pd.DatetimeIndex(df['date']).month

To extract out only year month from a date column in pandas

df['month_year'] = df['date_column'].dt.to_period('M')

Source: stackoverflow.com

Similar codes

4 votes281 views1 answer
Python zip file open as text
Python
0 vote218 views1 answer
Split string with first numerical value in python
Python
0 vote229 views1 answer
WAP THAT ASKS A USER FOR A NUMBER OF YEARS AND THEN PRINTS OUT THE NUMBER OF DAYS, HOURS ,MINUTES AND SECONDS IN THAT NO. OF YEARS.
Python
0 vote289 views1 answer
Django-multivaluedictkeyerror-error
Python
6 votes286 views3 answers
Python program to get the file size of a plain file.
Python
0 vote289 views2 answers
Python x y coordinates
Python
0 vote248 views1 answer
Pandas loc index not in
Python
0 vote276 views1 answer
Raise keyerror(key) from none os.environ
Python
0 vote292 views1 answer
Numpy aray map values with dictionary
Python
2 votes255 views2 answers
Instagram private account hacking code python
Python