Previously, you learned how to get all the data from a worksheet, a worksheet is a particular sheet
inside a Google spreadsheet, which could have multiple worksheets.
So we got the 2013 worksheet data and you also learn that if you want a particular role from those data,
you wanted to use indexing.
So if we apply a zero index there in the dots are variable and run.
We're going to get the very first row with Delta.
So this one with a temperature of minus 20, which is the very first row with delta rights.
We also have a heads of you.
So with an index of zero, we get the first records with Delta.
Now what if you want to get a row based on?
The internal Google Sheets coordinated system, which is, for example, let's suppose you want visceral
the internal Google Sheets System coordinate system is for this particular role.
It would be a five.
So this cell here a five for this cell up to let's say we want up to a five.
So we want.
These heroes here, a five five eight five eight five four that you would want to use another method
that is get values so you inputs a string, which is a range a five column E.
Five.
Don't use any space this year, so that is a delta variable.
And let's put the Delta variable here with other index run.
And this is the output 2013 one one three minus 19.
Let's check if that's right.
Yeah.
So 2013 one one three minus 19.
So that's how you get a particular role.
And if you wanted the entire room, you change that to F5 to include the pressure ulcer.
So that will add to one more value at the end of this list.
Now, pay attention to the format of this data here.
So it's a list of lists.
The values are inside the nest, at least as strings, you see.
Now this list of lists is beneficial if you want more rules, for example.
Let's see how to get these two rules or these three.
For that, you want to get the coordinates of the diagonal sales, which is the coordinates for this
and the coordinates for the extreme points.
This one here.
So we're looking at a five for this and f seven for that one.
So f seven, wrong, that's this time.
We really have a list of multiple lists.
So that is the first row that is the second row as a list and that is the third row.
All these three lists are inside a list, right?
Let's now see how to get a column.
So that was gets a four room or a rose gets a column.
So let's rename that to a row or rows and these two a column.
So again, we refer to the worksheet object that again is the same methods, gets values and it gets
a string.
So let's suppose we want this column.
For that, we would ride, see to to see 25.
See to to see 25 print column here, run.
I've got a Typekit.
It's good values, so sorry, run again.
And know that's the entire column.
However, this is not the best way to get a column because you see it's not the appropriate data type
a list of lists.
So a better way to get the values of a column is to use the call values methods, and this now gets
as inputs, an index.
So let's try to and see what we get.
So that is the month column.
Now it's a plain list, non nested lists here.
So the month column is the second column, this one here.
So as you can see, we get the entire column.
And also the indexing starts from a one with this method called values, right?
Let me change that to Colin, the comment.
So of course, if you don't want the month there, you could supply a slice syntax such as one up to
everything after the first.
And the month the head of the column is excluded from the results, so this is getting a column by index,
getting a row or rows by sales gets a column by index and there's also a method to get rows by index
the equivalent of call values.
It's a rule by index, so that is rows equals to worksheet one dot rule values.
So if you want the third row, for example, let's bring the rules here and see what we get.
And it's this rule with a temperature of minus 24, which corresponds with this one here.
So with an index of three.
You get that.
So that has an index of one that has an index of two and that has an index of three over again, you
could use the original methods which we used in the beginning of this video to get to one particular
role.
It's important to be consistent.
So just remember that's the index in here.
It starts from one.
And that's the end of this video.
In the next video, we're going to look at how to get the value of a particular cell and also how to
search for cells that have a particular value.
So I'll talk to you in the next video.