Write a Pandas program to get the day of month, day of year, week number and day of week from a given series of date strings
import pandas as pd from dateutil.parser import parse date_series = pd.Series(['01 Jan 2015', '10-02-2016', '20180307', '2014/05/06', '2016-04-12', '2019-04-06T11:20']) print("Original Series:") print(date_series) date_series = date_series.map(lambda x: parse(x)) print("Day of month:") print(date_series.dt.day.tolist()) print("Day of year:") print(date_series.dt.dayofyear.tolist()) print("Week number:") print(date_series.dt.weekofyear.tolist()) print("Day of week:") print(date_series.dt.weekday_name.tolist())
Sample Output:
Original Series: 0 01 Jan 2015 1 10-02-2016 2 20180307 3 2014/05/06 4 2016-04-12 5 2019-04-06T11:20 dtype: object Day of month: [1, 2, 7, 6, 12, 6] Day of year: [1, 276, 66, 126, 103, 96] Week number: [1, 39, 10, 19, 15, 14] Day of week: ['Thursday', 'Sunday', 'Wednesday', 'Tuesday', 'Tuesday', 'Saturday']
total answers (1)
start bookmarking useful questions and collections and save it into your own study-lists, login now to start creating your own collections.
Sample Output:
need an explanation for this answer? contact us directly to get an explanation for this answer