1
00:00:00,480 --> 00:00:04,530
Hey guys, welcome to Day 25 of 100 Days of Code.

2
00:00:04,980 --> 00:00:09,690
So today we're going to be learning about how to work with CSV files,

3
00:00:09,960 --> 00:00:13,620
so not just text files as we saw in yesterday's lessons.

4
00:00:13,950 --> 00:00:17,460
But we're going to be working with data files and we're going to be analyzing

5
00:00:17,460 --> 00:00:20,400
that data with a library called Pandas.

6
00:00:20,790 --> 00:00:24,000
This is one of the most popular Python data analysis libraries,

7
00:00:24,390 --> 00:00:27,960
and we're going to get to grips with how we can use it to start getting some

8
00:00:27,960 --> 00:00:31,680
insight into our data. By the end of the day,

9
00:00:31,710 --> 00:00:35,790
you're going to be building a educational and interesting game,

10
00:00:35,880 --> 00:00:40,880
which gets you to guess and learn all of the States in the US. And the

11
00:00:40,950 --> 00:00:43,800
inspiration comes from a quiz on Sporcle

12
00:00:44,130 --> 00:00:46,710
where it has a map of all the States,

13
00:00:46,740 --> 00:00:49,590
it's all blank until you start guessing some States,

14
00:00:49,890 --> 00:00:54,420
and then you keep going until you've managed to get all 50. Or like me,

15
00:00:54,420 --> 00:00:56,400
you get stuck at 30 out of 50.

16
00:00:56,730 --> 00:01:01,730
This game tests you on your knowledge of the names of the 50 States in the US.

17
00:01:02,370 --> 00:01:06,930
So for example, if I go and add another state and I hit

18
00:01:06,930 --> 00:01:07,763
OK,

19
00:01:07,890 --> 00:01:12,120
then that name appears on the map at the location of the state.

20
00:01:12,720 --> 00:01:17,720
The aim of the game is to remember all of the names of the states and to name as

21
00:01:20,010 --> 00:01:21,600
many of them as you can.

22
00:01:22,140 --> 00:01:25,980
So I managed to get to about only 30, um,

23
00:01:26,070 --> 00:01:29,760
but I've never lived in the US so my knowledge just comes from watching TV

24
00:01:29,760 --> 00:01:33,030
shows and general knowledge,

25
00:01:33,390 --> 00:01:36,000
but if you're from the US then you're probably going to do a lot better than

26
00:01:36,000 --> 00:01:36,660
me.

27
00:01:36,660 --> 00:01:41,580
So this is an interactive and educational game that I think that you are going

28
00:01:41,580 --> 00:01:45,600
to enjoy playing. So once you are ready, head over to the next lesson,

29
00:01:45,720 --> 00:01:50,070
and let's get started learning about how to work with data files.