1
00:00:00,540 --> 00:00:09,240
Previously, you learned how to get all the data from a worksheet, a worksheet is a particular sheet

2
00:00:09,240 --> 00:00:13,050
inside a Google spreadsheet, which could have multiple worksheets.

3
00:00:13,290 --> 00:00:20,520
So we got the 2013 worksheet data and you also learn that if you want a particular role from those data,

4
00:00:20,880 --> 00:00:22,410
you wanted to use indexing.

5
00:00:22,410 --> 00:00:28,020
So if we apply a zero index there in the dots are variable and run.

6
00:00:28,530 --> 00:00:32,390
We're going to get the very first row with Delta.

7
00:00:32,549 --> 00:00:40,220
So this one with a temperature of minus 20, which is the very first row with delta rights.

8
00:00:40,320 --> 00:00:41,460
We also have a heads of you.

9
00:00:41,820 --> 00:00:46,170
So with an index of zero, we get the first records with Delta.

10
00:00:46,770 --> 00:00:51,780
Now what if you want to get a row based on?

11
00:00:52,840 --> 00:01:00,940
The internal Google Sheets coordinated system, which is, for example, let's suppose you want visceral

12
00:01:01,600 --> 00:01:07,670
the internal Google Sheets System coordinate system is for this particular role.

13
00:01:07,690 --> 00:01:09,610
It would be a five.

14
00:01:09,850 --> 00:01:19,000
So this cell here a five for this cell up to let's say we want up to a five.

15
00:01:19,420 --> 00:01:20,410
So we want.

16
00:01:22,630 --> 00:01:32,080
These heroes here, a five five eight five eight five four that you would want to use another method

17
00:01:32,500 --> 00:01:41,950
that is get values so you inputs a string, which is a range a five column E.

18
00:01:42,190 --> 00:01:42,850
Five.

19
00:01:42,880 --> 00:01:47,470
Don't use any space this year, so that is a delta variable.

20
00:01:47,710 --> 00:01:52,550
And let's put the Delta variable here with other index run.

21
00:01:53,410 --> 00:01:58,630
And this is the output 2013 one one three minus 19.

22
00:01:59,020 --> 00:02:01,120
Let's check if that's right.

23
00:02:01,900 --> 00:02:02,190
Yeah.

24
00:02:02,200 --> 00:02:06,640
So 2013 one one three minus 19.

25
00:02:07,210 --> 00:02:09,699
So that's how you get a particular role.

26
00:02:10,729 --> 00:02:19,520
And if you wanted the entire room, you change that to F5 to include the pressure ulcer.

27
00:02:20,900 --> 00:02:24,260
So that will add to one more value at the end of this list.

28
00:02:24,920 --> 00:02:29,390
Now, pay attention to the format of this data here.

29
00:02:29,570 --> 00:02:32,900
So it's a list of lists.

30
00:02:35,290 --> 00:02:40,390
The values are inside the nest, at least as strings, you see.

31
00:02:40,610 --> 00:02:46,540
Now this list of lists is beneficial if you want more rules, for example.

32
00:02:46,930 --> 00:02:52,420
Let's see how to get these two rules or these three.

33
00:02:53,290 --> 00:03:01,000
For that, you want to get the coordinates of the diagonal sales, which is the coordinates for this

34
00:03:01,000 --> 00:03:04,900
and the coordinates for the extreme points.

35
00:03:05,080 --> 00:03:05,710
This one here.

36
00:03:05,920 --> 00:03:12,460
So we're looking at a five for this and f seven for that one.

37
00:03:13,240 --> 00:03:19,360
So f seven, wrong, that's this time.

38
00:03:20,110 --> 00:03:22,840
We really have a list of multiple lists.

39
00:03:23,080 --> 00:03:29,380
So that is the first row that is the second row as a list and that is the third row.

40
00:03:29,620 --> 00:03:33,280
All these three lists are inside a list, right?

41
00:03:33,850 --> 00:03:36,700
Let's now see how to get a column.

42
00:03:36,730 --> 00:03:43,630
So that was gets a four room or a rose gets a column.

43
00:03:45,520 --> 00:03:51,190
So let's rename that to a row or rows and these two a column.

44
00:03:52,210 --> 00:04:01,180
So again, we refer to the worksheet object that again is the same methods, gets values and it gets

45
00:04:01,180 --> 00:04:01,750
a string.

46
00:04:01,870 --> 00:04:04,840
So let's suppose we want this column.

47
00:04:07,040 --> 00:04:12,290
For that, we would ride, see to to see 25.

48
00:04:13,820 --> 00:04:19,850
See to to see 25 print column here, run.

49
00:04:21,350 --> 00:04:22,310
I've got a Typekit.

50
00:04:22,340 --> 00:04:25,070
It's good values, so sorry, run again.

51
00:04:26,930 --> 00:04:29,990
And know that's the entire column.

52
00:04:30,110 --> 00:04:37,310
However, this is not the best way to get a column because you see it's not the appropriate data type

53
00:04:37,320 --> 00:04:38,690
a list of lists.

54
00:04:39,530 --> 00:04:48,800
So a better way to get the values of a column is to use the call values methods, and this now gets

55
00:04:48,920 --> 00:04:50,120
as inputs, an index.

56
00:04:50,240 --> 00:04:52,670
So let's try to and see what we get.

57
00:04:53,890 --> 00:04:55,610
So that is the month column.

58
00:04:55,630 --> 00:05:00,100
Now it's a plain list, non nested lists here.

59
00:05:00,850 --> 00:05:05,020
So the month column is the second column, this one here.

60
00:05:05,260 --> 00:05:08,350
So as you can see, we get the entire column.

61
00:05:08,830 --> 00:05:13,990
And also the indexing starts from a one with this method called values, right?

62
00:05:17,360 --> 00:05:19,490
Let me change that to Colin, the comment.

63
00:05:20,030 --> 00:05:30,920
So of course, if you don't want the month there, you could supply a slice syntax such as one up to

64
00:05:31,220 --> 00:05:32,900
everything after the first.

65
00:05:35,510 --> 00:05:45,260
And the month the head of the column is excluded from the results, so this is getting a column by index,

66
00:05:45,770 --> 00:05:57,740
getting a row or rows by sales gets a column by index and there's also a method to get rows by index

67
00:05:57,740 --> 00:05:59,720
the equivalent of call values.

68
00:06:00,800 --> 00:06:11,480
It's a rule by index, so that is rows equals to worksheet one dot rule values.

69
00:06:12,500 --> 00:06:19,160
So if you want the third row, for example, let's bring the rules here and see what we get.

70
00:06:20,150 --> 00:06:27,680
And it's this rule with a temperature of minus 24, which corresponds with this one here.

71
00:06:28,250 --> 00:06:30,650
So with an index of three.

72
00:06:31,930 --> 00:06:33,430
You get that.

73
00:06:35,400 --> 00:06:43,380
So that has an index of one that has an index of two and that has an index of three over again, you

74
00:06:43,380 --> 00:06:49,110
could use the original methods which we used in the beginning of this video to get to one particular

75
00:06:49,110 --> 00:06:49,440
role.

76
00:06:50,070 --> 00:06:51,960
It's important to be consistent.

77
00:06:51,960 --> 00:06:55,010
So just remember that's the index in here.

78
00:06:55,020 --> 00:06:56,040
It starts from one.

79
00:06:56,800 --> 00:06:58,350
And that's the end of this video.

80
00:06:59,010 --> 00:07:05,430
In the next video, we're going to look at how to get the value of a particular cell and also how to

81
00:07:05,430 --> 00:07:08,280
search for cells that have a particular value.

82
00:07:08,370 --> 00:07:09,660
So I'll talk to you in the next video.