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
4 Aug 14, 2022
973 Jan 09, 2023
1 Sep 01, 2022
13 Oct 27, 2021
3 Jun 09, 2022
36 Sep 28, 2022
7 Oct 27, 2021
1.3k Jan 04, 2023
1 Feb 10, 2022
1 Dec 24, 2021
1.4k Dec 28, 2022
688 Jan 03, 2023
1 Oct 21, 2021
4 Oct 10, 2022
366 Oct 27, 2022
2 Jun 07, 2022