/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

-1 vote187 views1 answer
How to call a class in python
Python
0 vote248 views1 answer
Django generate openapi schema command line
Python Django
0 vote195 views1 answer
Python string caps lock
Python
1 vote199 views1 answer
Python how to sort by date
Python
0 vote192 views1 answer
Software developer tools list
Python
7 votes189 views5 answers
How to multiply two lists in python
Python
0 vote204 views1 answer
Rename one dataframe column python in inplace
Python
3 votes212 views1 answer
How to get number of cores in python
Python
0 vote276 views1 answer
Flask multuple parameters
Python
1 vote247 views2 answers
Pandas sort values group by
Python