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
1.9k Jan 04, 2023
2 Jun 15, 2021
27 Sep 03, 2022
22 Dec 21, 2022
2 Dec 19, 2022
280 Dec 19, 2022
2.3k Dec 31, 2022
2.9k Dec 27, 2022
12.1k Jan 06, 2023
12 Dec 14, 2022
3.4k Jan 06, 2023
1.6k Jan 07, 2023
3 Feb 12, 2022
67 Dec 28, 2022
93 Dec 28, 2022
1 Oct 21, 2021
3 Aug 06, 2021
205 Jan 01, 2023
1.4k Dec 28, 2022