Tag: data analysis
Growth Hacking
Growth hacking could happen only after market fit. if the business is not market fit yet, we cannot grow!! Business should know it’s target customers , … , Value proposition, To UI and UX Why do we stop growing? why? 5 whys of Facebook. (کتاب نوآوری و تجربه مشتری) What is Growth hacking test oriented… Continue reading Growth Hacking
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… Continue reading 5 ways to apply an IF condition in pandas DataFrame
Pandas Transform and Filter
Split Apply Combine Filter Data with Transform Transform with Lambda Filter with Pandas Groupby use Map to create a new Column see more also
فرمت اعداد در پانداس
برای فرمت سه رقم سه رقم جدا شده و نمایش تا دو رقم اعشار در پایتون پانداس از این کد استفاده ببرید. یا این کد برای هر ستون
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.… Continue reading Useful Python pandas codes
رابطه علّی
در تصمیمگیریهای کسبوکار بسیار اهمیت دارد که مدیران بتوانند رابطه علّی را درست تشخیص دهند. میتوان گفت در بیشتر موارد مدیریت یعنی ایجاد تغییر در چیزهایی که تحت کنترل است بهمنظور آنکه روی چیزهای دیگری که تحت کنترل نیست، اثر گذاشت تا به نتیجه دلخواه رسید. برای مثال یک مدیر بودجه تبلیغات سازمان خود را… Continue reading رابطه علّی
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… Continue reading 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… Continue reading Process mining – Introduction 1
Excel or any spreadsheet next order date or any related column
=IF ( AND (C2=C1,B2<>B1),D2,””)