/Python/Pandas extract month year from date

Pandas extract month year from date

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

Pandas extract month year from date

#if the date format comes in datetime, we can also extract the day/month/year using the to_period function
#where 'D', 'M', 'Y' are inputs
df['month_year'] = pd.to_datetime(df['birth_date']).dt.to_period('M')
df.head()

Source: interviewqs.com

Similar codes

-2 votes239 views1 answer
Ceil in python3
Python
0 vote267 views1 answer
Concatenacion python
Python
0 vote261 views1 answer
Read csv boto3
Python
0 vote288 views1 answer
Alan watts
Python
2 votes248 views2 answers
Big comments python
Python
0 vote260 views1 answer
Repalce na with mean per group
Python
2 votes243 views2 answers
Python get pixel color from screen
Python
1 vote251 views1 answer
Rename coordinate netcdf python xarray
Python
0 vote233 views1 answer
Python initialize dict with empty list values
Python
24 votes328 views6 answers
Django update model
Python Django