/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

0 vote288 views1 answer
Onetoone vs foreign key django
Python
0 vote319 views2 answers
Url namespaces for django rest router urls
Python Django
4 votes282 views3 answers
Python coin flip
Python
1 vote276 views1 answer
Pandas column rank
Python
0 vote267 views1 answer
Discord embed colors python
Python
11 votes274 views3 answers
How to pause a python script
Python
0 vote285 views1 answer
Boto3 read excel file from s3
Python
0 vote336 views1 answer
How to redirect in django rest framework
Python Django
22 votes289 views6 answers
Python how to add to a list
Python
1 vote268 views1 answer
How to move file from one location to another with python
Python