ROI 2/2
ã¡ãã¥ãŒã衚瀺ããã«ã¯ã¹ã¯ã€ãããŠãã ãã
As you can recognize from the previous chapter, we have some problems with ROI in general; we received -19.644756245106056%. Unfortunately, we suffer losses. In this case, we must dive deeper and find the reason.
The next step of our research is to check if we have unprofitable days.
ã¿ã¹ã¯
ã¹ã¯ã€ãããŠã³ãŒãã£ã³ã°ãéå§
- Group data:
- Extract only columns
'day', 'cost', 'money_spent'from thedfDataFrame. - Group by the column
'day'. - Apply
sum()function to grouped data. - Apply
reset_index()function.
- Create column
'ROI':
- Subtract
df['cost']fromdf['money_spent'] - Divide the result by
df['cost'].
解ç
å®è·µçãªç·Žç¿ã®ããã«ãã¹ã¯ãããã«åãæ¿ããäžèšã®ãªãã·ã§ã³ã®ãããããå©çšããŠãçŸåšã®å Žæããç¶è¡ãããã¹ãŠæ確ã§ãããïŒ
ãã£ãŒãããã¯ããããšãããããŸãïŒ
ã»ã¯ã·ã§ã³Â 4. ç« Â 10
single
AIã«è³ªåãã
AIã«è³ªåãã
äœã§ã質åããããææ¡ããã質åã®1ã€ãè©ŠããŠãã£ãããå§ããŠãã ãã
