In this video, I'll show you my solution on how to calculate the average of this column.
And that's my solution.
So I am establishing a connection to my Google Sheets account, creating a spreadsheet, creating a
work sheet and then getting the existing column.
So that column?
And, you know, that's the column will come as a list of lists, so we have to flatten that list.
I do that in this part here.
So I extracted the items from each list and convert them into a float or have a plane leaves or floats.
And then I calculate the average finally in here by just putting that existing column as input to the
mean function and then place that final value into the G.
Twenty 26 cell.
So I run this now, I go back here and I see the value placed in this G twenty six column.
That's the average.
Thank you for watching this video, and I'll talk to you in the next one.