Bitcoin Consider a record of a one-time investment in bitcoin with value of that investment tracked monthly, provided as an (ordered) tuple of dictionaries, where each dictionary comprises one key for...

Bitcoin

Consider a record of a one-time investment in bitcoin with value of that investment tracked monthly, provided as an (ordered) tuple of dictionaries, where each dictionary comprises one key for the month and corresponding one value for the value of the investment, and the first entry (Jan 2018) is the initial investment made on 01 Jan 2018, shown indatabelow.

Write Python code to take such a record of any length (the belowdatais only a sample), and output a table/dataframe comprising a row for each month with columns for date, start balance, and return.Print out this table/dataframe.

Also, visualize the record as two vertically arranged plots.

• The top plot should show a line plot of start balance vs. month


• The bottom plot should show a bar plot of return vs. month, with a black horizontal line at return=0, and bars color-coded such that positive returns are green and negative returns are red.


• The two plots' horizontal axes should align. Demonstrate that your code works by applying it todata.

Notes:

• The gain for each period is the end balance minus the start balance.


• The growth factor for each period is the end balance divided by the start balance.


• The return for each period is the growth factor minus 1.