1
00:00:04,760 --> 00:00:06,740
Hey everyone.

2
00:00:06,750 --> 00:00:10,110
So in the last video we also done with the you can do.

3
00:00:10,330 --> 00:00:13,110
And in this module so in this video just for practice.

4
00:00:13,110 --> 00:00:16,960
We are going to work with a big data that is U.S. city's population.

5
00:00:16,960 --> 00:00:21,580
This one is big enough to even crested Jupiter not look at what you are going to notice here.

6
00:00:22,450 --> 00:00:24,160
So now let's begin with that one.

7
00:00:24,160 --> 00:00:31,290
But before that first tree started Conan so that the original bear maybe not get updated.

8
00:00:31,780 --> 00:00:34,670
In that case we will get the output with this.

9
00:00:35,350 --> 00:00:36,820
Now that is done.

10
00:00:37,390 --> 00:00:41,630
And now Randi three files here 1 2 and 3.

11
00:00:41,650 --> 00:00:43,090
There you go.

12
00:00:43,090 --> 00:00:46,370
And again don't forget to Choose the directory figure using the extra.

13
00:00:46,420 --> 00:00:48,190
Any other location.

14
00:00:48,190 --> 00:00:51,700
Now let's begin with importing this one here.

15
00:00:52,060 --> 00:00:56,140
So we have a very variable popular denoting population.

16
00:00:57,040 --> 00:00:59,870
And that will be a period of great underscore CSP.

17
00:01:00,310 --> 00:01:12,820
And then pass and decodes U.S. cities space both dot CSP it done and then we go after that like the

18
00:01:12,820 --> 00:01:23,140
previous one create some variables that is first one let led underscore that is latitude Beal denoting

19
00:01:23,140 --> 00:01:29,690
population that will be equal to list of Popeil.

20
00:01:31,210 --> 00:01:42,230
And if we bring to the head of that one popular dot head here we have these four columns named Bob Boulet

21
00:01:42,280 --> 00:01:43,430
and no.

22
00:01:43,690 --> 00:01:44,250
Come on.

23
00:01:44,300 --> 00:01:49,170
Our next best is one here and require Here let.

24
00:01:49,560 --> 00:01:53,160
So here we have left shifted on David Big of over.

25
00:01:53,870 --> 00:01:54,250
Copy.

26
00:01:54,260 --> 00:02:00,310
This one is to tell or just write in the same set.

27
00:02:00,330 --> 00:02:05,010
This is loan technology to this one also loan.

28
00:02:05,910 --> 00:02:15,440
Similarly we have two more that is name this one also name because we will also print name with the

29
00:02:15,520 --> 00:02:23,700
population of that particular state or city then we have population that is B or B.

30
00:02:24,010 --> 00:02:27,590
And here we have B of being shifted on.

31
00:02:27,600 --> 00:02:28,540
David go with that.

32
00:02:29,350 --> 00:02:36,440
Now create a variable say B or for the voting population that will be first.

33
00:02:36,460 --> 00:02:52,380
We need to feature the group feature group and in that one does name equal to my men shifted on.

34
00:02:52,800 --> 00:02:56,080
Now update this one now that the map is created.

35
00:02:56,080 --> 00:03:01,430
And with this one we will update this one and for that we require the loop again.

36
00:03:01,510 --> 00:03:08,230
We begin with the for loop and this time we are going to have four values here latitude lonely dude

37
00:03:09,070 --> 00:03:17,110
name and population in zip of all these so zip.

38
00:03:17,110 --> 00:03:26,290
And then we have led them to escort Beal lone underscore Beal and then we have name underscore Beal

39
00:03:27,190 --> 00:03:36,460
and last pope underscored Beal and the dots and in that one search for that file

40
00:03:39,270 --> 00:03:39,990
just tragedy.

41
00:03:41,370 --> 00:03:45,450
So here we have the file that is we are going to do.

42
00:03:45,740 --> 00:03:56,480
Bill note and underscore child not defiled solely this index in that one pass photo marker.

43
00:03:56,700 --> 00:04:02,240
First thing we have location and then a location we have latitude and longitude.

44
00:04:02,700 --> 00:04:11,000
So let and longitude then we have a pope on message that is Pope up this time this one also going to

45
00:04:11,000 --> 00:04:17,030
be a list that is first the name or first represent the population.

46
00:04:17,210 --> 00:04:21,280
Then we have the name decides a comma there.

47
00:04:21,380 --> 00:04:27,240
Then we have the name after the last thing icon.

48
00:04:27,800 --> 00:04:31,730
And that will be volume note icon.

49
00:04:31,960 --> 00:04:45,910
And in that one white color equal to say blue and shifted on so here this cell is not done processing

50
00:04:45,910 --> 00:04:51,090
and I have already done this one by just posing the beauty of what I find.

51
00:04:51,190 --> 00:04:56,180
Because in that case I have done it in front of you it will take a lot of time.

52
00:04:56,200 --> 00:05:02,860
Also one thing here I have added B or B you hear that is BP because our variable is B or B here.

53
00:05:02,860 --> 00:05:07,380
That would not show you at all but will not work here.

54
00:05:07,420 --> 00:05:08,920
Now let me move to this one.

55
00:05:09,100 --> 00:05:10,540
And don't forget to choose that one.

56
00:05:11,140 --> 00:05:14,230
So here is the graph you are going to get.

57
00:05:14,230 --> 00:05:19,120
And as you can see here I am scrolling but my Jupiter notebooks are not working fine.

58
00:05:19,480 --> 00:05:27,020
And when I try to let me make this one two this one man I tried to click on zoom as you can see here

59
00:05:27,130 --> 00:05:30,380
I have clicked there but nothing is happening here.

60
00:05:30,460 --> 00:05:34,900
This will work but it will take a time like this one doing right now.

61
00:05:35,620 --> 00:05:43,320
So for that one I have again and the same command in a different cell that is mapped out and underscored

62
00:05:43,340 --> 00:05:46,250
child and then positive variable over population.

63
00:05:46,240 --> 00:05:52,840
Hey I have zoomed the data so that you can have a proper view there but you not able to see that what

64
00:05:52,840 --> 00:05:53,650
is happening there.

65
00:05:53,950 --> 00:06:05,020
Because this one is a big mess now here on this one when you click any of these like this one he will

66
00:06:05,020 --> 00:06:17,690
get the population and the name that is also not working properly like on this one 7 3 0 1 Corbin Bowling

67
00:06:17,690 --> 00:06:22,130
Green and there we have 3 1 1 4 7.

68
00:06:22,130 --> 00:06:30,190
So this is what big data files look with these do your plotting maps and in the next video we will do

69
00:06:30,290 --> 00:06:38,350
something modified this one because we have all these light blue icons showing a bunch of these tanks.

70
00:06:38,630 --> 00:06:40,700
That is something not much user friendly.

71
00:06:41,300 --> 00:06:45,280
So in the next video we will make this one a little interface friendly.

72
00:06:45,920 --> 00:06:46,820
So thanks for watching.

73
00:06:46,820 --> 00:06:47,720
Soon the next video.