/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

16 votes119 views6 answers
Pandas python install
Python
3 votes189 views2 answers
How to add element at first position in array python
Python
0 vote116 views1 answer
Intialising a tuple in python
Python
5 votes138 views10 answers
Online python to c converter
Python
1 vote123 views1 answer
How to print x in python
Python
0 vote176 views1 answer
Insert a new row to numpy array in especific position
Python
1 vote121 views1 answer
How many data types are specified to numeric values in python
Python
2 votes149 views1 answer
How store list in django session
Python Django
1 vote129 views1 answer
Find and count unique values of a single column in Pandas DataFrame
Python
0 vote134 views1 answer
Docker python heelo world doesnt print anything
Python