Tag Archives: python for business analysts

Pandas Example – Write a Pandas program to check if a day is a business day (weekday) or not

(Python Example for Beginners)   Write a Pandas program to check if a day is a business day (weekday) or not.   Sample Solution: Python Code : import pandas as pd def is_business_day(date): return bool(len(pd.bdate_range(date, date))) print(“Check busines day or not?”) print(‘2020-12-01: ‘,is_business_day(‘2020-12-01’)) print(‘2020-12-06: ‘,is_business_day(‘2020-12-06’)) print(‘2020-12-07: ‘,is_business_day(‘2020-12-07’)) print(‘2020-12-08: ‘,is_business_day(‘2020-12-08’)) Sample Output: Check busines day or …

Pandas Example – Write a Pandas program to convert year and day of year into a single datetime column of a dataframe

(Python Example for Beginners)   Write a Pandas program to convert year and day of year into a single datetime column of a dataframe.   Sample Solution: Python Code : import pandas as pd data = { “year”: [2002, 2003, 2015, 2018], “day_of_the_year”: [250, 365, 1, 140] } df = pd.DataFrame(data) print(“Original DataFrame:”) print(df) df[“combined”] …

Pandas Example – Write a Pandas program to create a time series using three months frequency

(Python Example for Beginners)   Write a Pandas program to create a time series using three months frequency.   Sample Solution: Python Code : import pandas as pd time_series = pd.date_range(‘1/1/2021′, periods = 36, freq=’3M’) print(“Time series using three months frequency:”) print(time_series) Sample Output: Time series using three months frequency: DatetimeIndex([‘2021-01-31’, ‘2021-04-30’, ‘2021-07-31’, ‘2021-10-31’, ‘2022-01-31’, …

Pandas Example – Write a Pandas program to create a time series object that has time indexed data

(Python Example for Beginners)   Write a Pandas program to create a time series object that has time indexed data. Also select the dates of same year and select the dates between certain dates.   Sample Solution: Python Code : import pandas as pd index = pd.DatetimeIndex([‘2011-09-02’, ‘2012-08-04’, ‘2015-09-03’, ‘2010-08-04’, ‘2015-03-03’, ‘2011-08-04’, ‘2015-04-03’, ‘2012-08-04’]) s_dates …

Pandas Example – Write a Pandas program to create a time-series with two index labels and random values

(Python Example for Beginners)   Write a Pandas program to create a time-series with two index labels and random values. Also print the type of the index.   Sample Solution: Python Code : import pandas as pd import numpy as np import datetime from datetime import datetime, date dates = [datetime(2011, 9, 1), datetime(2011, 9, …

Pandas Example – Write a Pandas program to print the day after and before a specified date

(Python Example for Beginners)   Write a Pandas program to print the day after and before a specified date. Also print the days between two given dates.   Sample Solution: Python Code : import pandas as pd import datetime from datetime import datetime, date today = datetime(2012, 10, 30) print(“Current date:”, today) tomorrow = today …

Pandas Example – Write a Pandas program to create a date from a given year, month, day and another date from a given string formats

(Python Example for Beginners)   Write a Pandas program to create a date from a given year, month, day and another date from a given string formats.   Sample Solution: Python Code : from datetime import datetime date1 = datetime(year=2020, month=12, day=25) print(“Date from a given year, month, day:”) print(date1) from dateutil import parser date2 …

Pandas Example – Write a Pandas program to create Time Series Objects

(Python Example for Beginners)   Write a Pandas program to create a) Datetime object for Jan 15 2012. b) Specific date and time of 9:20 pm. c) Local date and time. d) A date without time. e) Current date. f) Time from a datetime. g) Current local time.   Sample Solution: Python Code : import …

Pandas Example – Write a Pandas program to split a given dataset using group by on multiple columns and drop last n rows of from each group

(Python Example for Beginners)   Write a Pandas program to split a given dataset using group by on multiple columns and drop last n rows of from each group.   Test Data: ord_no purch_amt ord_date customer_id salesman_id 0 70001 150.50 2012-10-05 3002 5002 1 70009 270.65 2012-09-10 3001 5003 2 70002 65.26 2012-10-05 3001 5001 …

Pandas Example – Write a Pandas program to split the following dataset using group by on first column and aggregate over multiple lists on second column

(Python Example for Beginners)   Write a Pandas program to split the following dataset using group by on first column and aggregate over multiple lists on second column.   Test Data: student_id marks 0 S001 [88, 89, 90] 1 S001 [78, 81, 60] 2 S002 [84, 83, 91] 3 S002 [84, 88, 91] 4 S003 …