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
45 Jul 31, 2022
17.9k Dec 31, 2022
24 Jan 02, 2023
1.4k Dec 15, 2022
92 Dec 26, 2022
3 May 14, 2022
142 Dec 25, 2022
227 Jan 05, 2023
2 Jun 15, 2021
65 Sep 12, 2022
2 Dec 26, 2021
239 Jan 08, 2023
6.3k Jan 01, 2023
2 Jan 16, 2022
149 Dec 29, 2022
138 Dec 06, 2022
46 Sep 18, 2022
0 Jun 25, 2022
27 Jan 04, 2023
2 Jan 07, 2023