<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Country</th>
      <th>Year</th>
      <th>Coffee Consumption (kg per capita per year)</th>
      <th>Average Coffee Price (USD per kg)</th>
      <th>Type of Coffee Consumed</th>
      <th>Population (millions)</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Country_39</td>
      <td>2023</td>
      <td>9.253939</td>
      <td>6.467453</td>
      <td>Americano</td>
      <td>65.929478</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Country_29</td>
      <td>2011</td>
      <td>9.981203</td>
      <td>4.346744</td>
      <td>Mocha</td>
      <td>82.456680</td>
    </tr>
    <tr>
      <th>2</th>
      <td>Country_15</td>
      <td>2020</td>
      <td>3.312916</td>
      <td>8.767496</td>
      <td>Latte</td>
      <td>110.938862</td>
    </tr>
    <tr>
      <th>3</th>
      <td>Country_43</td>
      <td>2005</td>
      <td>2.436180</td>
      <td>11.748750</td>
      <td>Espresso</td>
      <td>43.137207</td>
    </tr>
    <tr>
      <th>4</th>
      <td>Country_8</td>
      <td>2019</td>
      <td>4.637849</td>
      <td>8.999099</td>
      <td>Mocha</td>
      <td>65.484262</td>
    </tr>
  </tbody>
</table>
</div>

      Country  Year  Coffee Consumption (kg per capita per year)  \
0  Country_39  2023                                     9.253939   
1  Country_29  2011                                     9.981203   
2  Country_15  2020                                     3.312916   
3  Country_43  2005                                     2.436180   
4   Country_8  2019                                     4.637849   

   Average Coffee Price (USD per kg) Type of Coffee Consumed  \
0                           6.467453               Americano   
1                           4.346744                   Mocha   
2                           8.767496                   Latte   
3                          11.748750                Espresso   
4                           8.999099                   Mocha   

   Population (millions)  
0              65.929478  
1              82.456680  
2             110.938862  
3              43.137207  
4              65.484262  

Analysis of Coffee Consumption and Pricing Trends Over Time

provide me 100 insights

Visualizations

What is the trend of coffee prices over the years?

Can you show the correlation between coffee consumption and population?

Average Coffee Price through the Years

Coffee type consumption tendencies each year

Coffee type consumption tendencies each year with bars

Coffee type consumption tendencies each year with bars most beautiful way

Coffee type consumption tendencies each year with piechart

Country	Year	Coffee Consumption (kg per capita per year)	Average Coffee Price (USD per kg)	Type of Coffee Consumed	Population (millions)
Country_39	2023	9.253939	6.467453	Americano	65.929478
Country_29	2011	9.981203	4.346744	Mocha	82.456680
Country_15	2020	3.312916	8.767496	Latte	110.938862
Country_43	2005	2.436180	11.748750	Espresso	43.137207
Country_8	2019	4.637849	8.999099	Mocha	65.484262