covid-19-data | Data on COVID-19 (coronavirus) cases, deaths, hospitalizations, tests • All countries • Updated dail | Dataset library

I'm working on Covid data from Our World in Data. The data is very well-documented from the start. It is adding record for every progress(for every vaccination/deaths etc). It has 67 columns and more than 161K records.
For every record that is being added, life_expectancy is calculated. I wanted to calculate the average life_expectancy per location till date. For eg: Mexico has around 750 entries and has life_expectancy for every record. I want to take average for all the 750 life_expectancy. For this, I planned to pick up entry of each country and then calculate the average of life_expectancy and then add it to new dictionary. My way got me incorrect data and also took more than 1 min to complete.

covid.head():

Here's what I tried:

I get this error:

So I have two data sets the first being the OWID Covid-19 Dataset available here, it contains a column including location names and the total number of new covid cases for each day reported. It looks something like this: I would like to add the total number of new cases column but only for a specific location, the only methods we have been taught on my course are for totalling the whole column, but I would only like to add the rows corresponding to specific location for example Afghanistan, to then get a total number of covid cases for that country (by adding the total number of new cases).

After this is complete I would like to then add this result to another dataset, as a new column for the locations total Covid-19 cases, the dataset I am adding this to looks like this (so for each location there should be a new column with their total number of covid cases corresponding to each location):

TLDR:

1. How do I add rows of a column relating to a specific variable in another column, or just by entering row/column number?
2. How would I then add this results to another data set by the location name?

I'm a beginner in matplotlib. I've already created some graphs from a dataframe. Now I want to create the average graph from multiple graphs.

Can anyone help me with this?

My graphs look like this:

I'm trying to show the growth of COVID cases in New York state

This code gets the plot I want but without the animation or aspect of time.

Full error:

Error in insert_points(polygon$x, polygon$y, splits, n):
Not compatible with requested type: [type=NULL; target=double].

I am building the choropleth map regarding the vaccination rate over the world. To plot with sequential color, I use Plotly to plot the map, and use streamlit to render the map on the webpage with Python. However, the map is too small, I've tried the fig.update_layout() to adjust the size, but the map is not centered. The "view fullscreen" on the toolbar exactly solves my problem as it's centered and always fits the screen. Thus, is there any way to keep it fullscreen?

Here is my code:

I want to create a dataframe from the owid covid19 json data located here. The json has an array of daily records in the data column, this along with the country index is what I'm trying to make into a dataframe.

I have this dataset which is COVID dataset per county and state. I also have this state population dataset as well. I probably need to somehow merge the two dataset together and plot the number of cases and death per capita. How can I plot the number of cases and death per capita for each state?

I have the following code for the merging but it repeats the state over and over and doesn't work.

I'm getting error:

Error tokenizing data. C error: Expected 1 fields in line 88, saw 4

while trying to read this data: