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
125 Dec 24, 2022
0 Jan 12, 2022
156 Jan 03, 2023
7 Dec 28, 2022
3 Dec 14, 2022
4.3k Dec 28, 2022
70 Dec 27, 2022
9.4k Jan 07, 2023
251 Dec 19, 2022
5 Nov 08, 2022
123 Dec 25, 2022
265 Nov 21, 2022
18 Sep 11, 2022
6 Oct 04, 2022
4 Apr 14, 2022
1 Dec 24, 2021
84 Mar 25, 2022
1k Jan 02, 2023
723 Jan 07, 2023
122 Dec 21, 2022