Pandas has many inbuilt methods that can be used to extract the month from a given date that are being generated randomly using the random function or by using Timestamp function or that are transformed to date format using the to_datetimefunction. Let’s see few examples for better understanding.
Example 1
import pandas as pd dti = pd.date_range('2020-07-01', periods = 4, freq ='M')print(dti.month) |
Output:
Int64Index([7, 8, 9, 10], dtype='int64')
Example 2
import pandas as pdimport numpy as npimport datetime date1 = pd.Series(pd.date_range('2020-7-1 12:00:00', periods = 5))df = pd.DataFrame(dict(date_given = date1)) df['month_of_date'] = df['date_given'].dt.monthdf |
Output:
Example 3
import pandas as pdimport datetimeimport numpy as np dates =['14 / 05 / 2017', '2017', '07 / 09 / 2017'] frame = pd.to_datetime(dates, dayfirst = True)frame = pd.DataFrame([frame]).transpose()frame['date']= frameframe['month']= frame['date'].dt.monthframe.drop(0, axis = 1, inplace = True) frame |
Output:
