/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 vote309 views1 answer
Pandas read csv skip until expression found
Python
0 vote316 views1 answer
Full dist upgrade kali
Python
10 votes311 views4 answers
Write text in list to text file python
Python
0 vote401 views1 answer
Setting flask app environment variable
Python Flask
2 votes368 views2 answers
Print labels on confusion_matrix
Python
0 vote336 views1 answer
How to change padding of dbc.col
Python
0 vote338 views1 answer
Matp[lotlib max y value
Python
0 vote362 views2 answers
Django pagination class based views
Python Django
52 votes342 views2 answers
What is index in list in python
Python
4 votes331 views1 answer
Replace empty string and "records with only spaces" with npnan pandas
Python