5 ways to apply an IF condition in pandas DataFrame

from Need to apply an IF condition in Pandas DataFrame? If so, in this tutorial, you’ll see 5 different ways to apply such a condition. Specifically, you’ll see how to apply an IF condition for: Set of numbers Set of numbers and lambda Strings Strings and lambada OR condition Applying an IF condition in Pandas DataFrame… ادامه خواندن 5 ways to apply an IF condition in pandas DataFrame

Useful Python pandas codes

– 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 of a string with a delimitter df[“cat”] = df[“CategoryID”].str.split(‘,’,1).str[0] – filling na or nan or Null values df[“CategoryID”].fillna(“”,inplace=True) – Convert To date time pd.to_datetime(df[“start_date”],errors=’ignore’) combination of where and select some.… ادامه خواندن Useful Python pandas codes

رابطه علّی

در تصمیم‌گیری‌های کسب‌وکار بسیار اهمیت دارد که مدیران بتوانند رابطه علّی را درست تشخیص دهند. می‌توان گفت در بیشتر موارد مدیریت یعنی ایجاد تغییر در چیزهایی که تحت کنترل است به‌منظور آن‌که روی چیزهای دیگری که تحت کنترل نیست، اثر گذاشت تا به نتیجه دلخواه رسید. برای مثال یک مدیر بودجه تبلیغات سازمان خود را… ادامه خواندن رابطه علّی

Process mining – Introduction 2

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 Machine learning: Supervised learning: response variable that labels each instance (we labeled each data and the machine will learn from that) Classification: classify to predict (i.e. decision tree) Regression: final… ادامه خواندن Process mining – Introduction 2

Process mining – Introduction 1

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) Activity (purchased, Request, rejected, …) Time stamp Process mining Internet of events Big data Internet of contents (google, Wikipedia) Social media Internet of people Cloud Internet of things Mobility Internet… ادامه خواندن Process mining – Introduction 1

How to add Business intelligence in visual studio 2017

How to add Business intelligence in visual studio 2017 How to add Business intelligence in VS 2017 It is so easy just install this package fro reporting service and this package for  Analysis service