Jalali Pandas Extentsion
A pandas extension that solves all problems of Jalai/Iraninan/Shamsi dates
Features
Series Extenstion
- Convert string to Jalali date
1388/03/25-->jdatetime(1388,3,25,0,0) - Convert Georgian date to Jalali date
datetime(2019,11,17,0,0)-->jdatetime(1398,8,26,0,0) - Convert Jalali date to Georgian date
jdatetime(1398,10,18,0,0)-->datetim(2020,1,8,6,19)
DataFrame extenstion
- Support grouping by Jalali date
- Group by year, month, days, ...
- Shortcuts for groups:
ymdfor['year','month','day']and more - Resampling: Convenience method for frequency conversion and resampling of time series but in Jalali dateformat. (comming soon)
Installation
pip install -U jalali-pandas
Usage
Just import jalali-pandas and use pandas just use .jalali as a method for series and dataframes. Nothin outside pandas.
jalali-pandasis an extentsion for pandas, that add a mehtod for series/columns and dataframes.
Series
import pandas as pd
import jalali_pandas
# create dataframe
df = pd.DataFrame({"date": pd.date_range("2019-01-01", periods=10, freq="D")})
# convert to jalali
df["jdate"] = df["date"].jalali.to_jalali()
# convert to gregorian
df["gdate"] = df["jdate"].jalali.to_georgian()
# parse string to jalali
df1 = pd.DataFrame({"date": ["1399/08/02", "1399/08/03", "1399/08/04"]})
df1["jdate"] = df1["date"].jalali.parse_jalali("%Y/%m/%d")
# get access to jalali year,quarter ,month, day and weekday
df['year'] = df["jdate"].jalali.year
df['month'] = df["jdate"].jalali.month
df['quarter'] = df["jdate"].jalali.quarter
df['day'] = df["jdate"].jalali.day
df['weekday'] = df["jdate"].jalali.weekday
DataFrame
import pandas as pd
import jalali_pandas
df = pd.DataFrame(
{
"date": pd.date_range("2019-01-01", periods=10, freq="M"),
"value": range(10),
}
)
# make sure to create a column with jalali datetime format. (you can use any name)
df["jdate"] = df["date"].jalali.to_jalali()
# group by jalali year
gp = df.jalali.groupby("year")
gp.sum()
#group by month
mean = df.jalali.groupby('mean')
#groupby year and month and day
mean = df.jalali.groupby('ymd')
# or
mean = df.jalali.groupby(['year','month','day'])
#groupby year and quarter
mean = df.jalali.groupby('yq')
# or
mean = df.jalali.groupby(['year','quarter'])
ToDos:
- add Georgian to Jalali Conversion
- add Jalali to Georgian Conversion
- add support for sampling
- add date parser from other columns
- add date parser from string
342 Oct 26, 2022
6.8k Feb 18, 2021
2.1k Feb 18, 2021
349 Feb 15, 2021
2k Feb 17, 2021
614 Feb 17, 2021
317 Feb 17, 2021
1.2k Jan 1, 2023
675 Dec 09, 2022
2 Dec 22, 2021
19 Nov 30, 2022
8 Nov 01, 2022
110 Dec 22, 2022
1 Jan 11, 2022
611 Dec 29, 2022
3 Jun 28, 2021
2 Dec 13, 2021
239 Nov 10, 2022
145 Jan 01, 2023
43 Sep 03, 2022
48 Dec 05, 2022
145 Dec 20, 2022
3 Dec 25, 2021
5 Dec 19, 2021
134 Dec 15, 2022
169 Dec 27, 2022
28 Dec 14, 2022
17.1k Dec 31, 2022