def MonthsAfter(a): c = a[‘ShamsiYearMonth’] – a[‘CohortGroup’] if c>۱۲: return c-88 else : return c# mg[‘MonthsAfterFirst’]mg.apply(lambda x: MonthsAfter(x),axis=1)
from What Code single column df[‘food’] multiple columns df[[‘color’, ‘food’, ‘score’]] single row df.loc[‘Niko’] multiple rows df.loc[[‘Niko’, ‘Penelope’]] slice notation to select a range of…
df[‘PriceBin’] = pd.cut(df[‘PriceAvg’], bins = 3)df[‘PriceBin’].value_counts() (۵۴۰۶۰.۰, ۲۰۴۰۰۰۰.۰] ۲۰۹ (۲۰۴۰۰۰۰.۰, ۴۰۲۰۰۰۰.۰] ۴ (۴۰۲۰۰۰۰.۰, ۶۰۰۰۰۰۰.۰] ۱ Name: PriceBin, dtype: int64 df[‘PriceBin’] = pd.qcut(df[‘PriceAvg’], q=3) df[‘PriceBin’].value_counts().sort_index() (۵۹۹۹۹.۹۹۹,…
– To Rename the data framedf.rename(columns={“contract_id”:”deal_id”},inplace=True) – Where statement tips[tips[‘time’] == ‘Dinner’].head(۵) – vlookupmg = pd.merge(df,AgReg,on=”deal_id”,how=”left”) – choose the first column of an array or first part…
Case ID Activity Name Time Stamp Play out: A possible scenario Play in: simple process allowing for 4 traces Replay Process mining: Discovery Conformance Enhancement…
Process mining is the combination of Data mining and Business process management. It works with log files. Every log file must have: Case ID (order ID)…
If you knew SQL before and want to migrate to Python, you can use this article. TiTle SQL Pandas Desc Simple SELECT total_bill, tip, smoker,…
=IF ( AND (C2=C1,B2<>B1),D2,””)
از اینجا معمولاً اگر شما یک وبسایت داشته باشید، گهگاه مشکلاتی برایتان رخ میدهد که نیاز دارید برای رفع آن به بخش خدمات مشتریان شرکت…
I made a new rule for my online searches. If my search fails in ten minutes, then I need to change my search. یه قانون…