profitability('my old bike', 100, 10, ['spring', 'summer'], 2)

profitability('my old bike', 100, 1, ['summer'], 2)

# Describe the purchase
purchase_name_b = 'bike'
price_b = 400
usage_years_b = [y/2 for y in range(2, 21, 1)] # from 1 to 10 years
usage_seasons_b = [['summer']] # cycling only in summer
usage_per_week_b = [1,2,3,5] # once a week, on weekends, time to time, on weekdays
price_sale_pct_b = 0 # do not sell

columns = ['purchase_name', 'price', 'usage_years',
           'usage_seasons', 'usage_per_week', 'profitability'
          ]

profitability_bike = pd.DataFrame()
for years in usage_years_b:
    for seasons in usage_seasons_b:
        for times in usage_per_week_b:
            pra_bike = profitability(purchase_name_b, price_b, years, seasons, times, price_sale_pct_b)
            profitability_bike = profitability_bike.append(pra_bike)
            
profitability_bike.head()

profitability_bike.describe()

profitability_bike.info()

# Increase the number of rows to display
pd.set_option('display.max_rows', 100)

profitability_bike.sort_values(by='price_per_usage')

# Color palette for the data
palette = 'tab10'

# Inscriptions
title = """Bike Profitability"""
description = """
The real cost of the bike depending on the frequency of use.
Data: @data.sugar | Author: @data.sugar
"""

# Plot size
figsize = (6,4)

# Set the figure
sns.set(context='paper', style='ticks', palette=snark_palette,
        rc={'axes.spines.left': True, 'axes.spines.bottom': True,
            'axes.spines.right': False, 'axes.spines.top': False
           }
       )

# Create the plot
fig, ax = plt.subplots(1, 1, figsize=figsize, facecolor='w')
sns.lineplot(data=profitability_bike,
             x='usage_years', y='price_per_usage',
             hue='usage_per_week',
             lw=2, palette=palette,
             legend='full', ax=ax
            )

# Set some aesthetic params for the plot
ax.set_title(title, fontdict={'fontsize': 16}, loc='center', pad=10, c=snark_palette[-1]) # set a title of the plot
ax.annotate(description, xy=(10, -4), size=6, xycoords='figure points', c=snark_palette[-1])
ax.set_xlabel('years of use', loc='center', size='x-large', c=snark_palette[-1]) # set label of x axis
ax.set_ylabel('$ per use', loc='center', size='x-large', c=snark_palette[-1]) # set label of y axis
ax.tick_params(axis='both', labelsize='large', colors=snark_palette[-1]) # set x/y ticks
ax.spines['bottom'].set_color(snark_palette[-1]) # color x axis
ax.spines['left'].set_color(snark_palette[-1]) # color y axis
ax.set_xticks([i for i in range(1, 11)]) # set x ticks labels
ax.set_xlim(1,10)
ax.set_ylim(0, 16)
ax.legend(loc='upper right', frameon=False).texts[0].set_text('')
ax.text(s='times used\nper week\nin summer', x=9.3, y=15, ha='center')

# Save and plot
plt.savefig('plot.pic/plot.bike.png', dpi=150, bbox_inches='tight')
plt.show()

blog_post = r"""
## 🚴‍♀️Do I need a bike?  


My \#bike is 10 years old.  
It cost \$100, but I still use it today.   

👀Thinking about \#conscious \#consumption I wondered how profitably I invested that \$100 in my bike?  

📌I have prepared a simple \#calculator to help prevent spontaneous purchases.  

I have tested it to answer if my old bike is \#useful acquisition.

✔For 10 years now, I've been cycling twice a week in the spring and summer, and I "pay" 19 cents each time.  
It seems to be a bargain.

✔What if reduce the usage years to 1 and leave only summer for cycling?  
The cost has increased to $3.85 at a time (or an hour) and is no longer so attractive.

✔One use can be understood as one hour of cycling or two hours, for example.

🤍Recently, I liked a new bike in the store.
I could have made a spontaneous, thoughtless purchase, given into the mood.
However, now I would like to estimate how much the new bike will actually cost me.  
So I did the calcs.

I considered some of the uses for my new bike:

◽I'll buy it in the store for \$400.  
◽I'll use it 1, 2, 4, 5, 6, 7, 8, 9 or 10 years.  
◽I plan to cycle only in summer.  
◽I want to cycle, maybe once a week, or on weekends, or time to time, or on weekdays.  
◽I'm not going to sell it.  

📝Do I still need a bike?  

If renting a bike in my city costs $1 an hour, then I have to cycle whole summer for at least 6 years to justify the purchase.  

(Need to calc your own purchases? Follow the link in bio for the profitability calc!)  
.  
.  
.  
\#funtime \#probably \#datascience \#datapower \#data_sugar_profit \#consciousconsumption
\#data_know_everything_and_nothing \#linkinbio \#datajournalism
"""

# Check post text length for Instagram
len(blog_post)

from IPython.display import Markdown as md
md(blog_post)