WEBVTT

0
00:00.480 --> 00:04.530
Hey guys, welcome to Day 25 of 100 Days of Code.

1
00:04.980 --> 00:09.690
So today we're going to be learning about how to work with CSV files,

2
00:09.960 --> 00:13.620
so not just text files as we saw in yesterday's lessons.

3
00:13.950 --> 00:17.460
But we're going to be working with data files and we're going to be analyzing

4
00:17.460 --> 00:20.400
that data with a library called Pandas.

5
00:20.790 --> 00:24.000
This is one of the most popular Python data analysis libraries,

6
00:24.390 --> 00:27.960
and we're going to get to grips with how we can use it to start getting some

7
00:27.960 --> 00:31.680
insight into our data. By the end of the day,

8
00:31.710 --> 00:35.790
you're going to be building a educational and interesting game,

9
00:35.880 --> 00:40.880
which gets you to guess and learn all of the States in the US. And the

10
00:40.950 --> 00:43.800
inspiration comes from a quiz on Sporcle

11
00:44.130 --> 00:46.710
where it has a map of all the States,

12
00:46.740 --> 00:49.590
it's all blank until you start guessing some States,

13
00:49.890 --> 00:54.420
and then you keep going until you've managed to get all 50. Or like me,

14
00:54.420 --> 00:56.400
you get stuck at 30 out of 50.

15
00:56.730 --> 01:01.730
This game tests you on your knowledge of the names of the 50 States in the US.

16
01:02.370 --> 01:06.930
So for example, if I go and add another state and I hit

17
01:06.930 --> 01:07.763
OK,

18
01:07.890 --> 01:12.120
then that name appears on the map at the location of the state.

19
01:12.720 --> 01:17.720
The aim of the game is to remember all of the names of the states and to name as

20
01:20.010 --> 01:21.600
many of them as you can.

21
01:22.140 --> 01:25.980
So I managed to get to about only 30, um,

22
01:26.070 --> 01:29.760
but I've never lived in the US so my knowledge just comes from watching TV

23
01:29.760 --> 01:33.030
shows and general knowledge,

24
01:33.390 --> 01:36.000
but if you're from the US then you're probably going to do a lot better than

25
01:36.000 --> 01:36.660
me.

26
01:36.660 --> 01:41.580
So this is an interactive and educational game that I think that you are going

27
01:41.580 --> 01:45.600
to enjoy playing. So once you are ready, head over to the next lesson,

28
01:45.720 --> 01:50.070
and let's get started learning about how to work with data files.