1
00:00:00,000 --> 00:00:03,790
Yeah, let's move on with the txt file. So it's

2
00:00:03,810 --> 00:00:07,980
a supermarkets separated by commas. So

3
00:00:07,980 --> 00:00:09,600
it's a data structure separated by

4
00:00:09,600 --> 00:00:12,455
commas. For that, so for

5
00:00:12,479 --> 00:00:14,502
[No audio]

6
00:00:14,527 --> 00:00:16,439
txt files separated by commas,

7
00:00:16,464 --> 00:00:18,464
[No audio]

8
00:00:18,489 --> 00:00:20,195
again, you use read_csv.

9
00:00:20,219 --> 00:00:26,915
[No audio]

10
00:00:26,940 --> 00:00:31,325
just like that df4, and here is the

11
00:00:31,350 --> 00:00:35,188
DataFrame. So this supermarkets.csv

12
00:00:35,212 --> 00:00:37,200
actually, some say it's a comma

13
00:00:37,200 --> 00:00:38,790
separated file, but to be more

14
00:00:38,790 --> 00:00:40,920
accurate, you'd say a character separated

15
00:00:40,920 --> 00:00:44,370
values. So c is for character. And you

16
00:00:44,370 --> 00:00:45,420
know, there might be different

17
00:00:45,420 --> 00:00:47,820
characters there. In this case, when you

18
00:00:47,820 --> 00:00:50,310
have commas as separators, you don't

19
00:00:50,310 --> 00:00:52,830
have to pass any separator parameter

20
00:00:52,830 --> 00:00:55,650
here. But when you have other values

21
00:00:55,680 --> 00:00:59,010
as separators, you will have to pass that, and that

22
00:00:59,048 --> 00:01:06,421
is the next scenario. So df5 pandas.read_csv,

23
00:01:06,927 --> 00:01:08,670
so we're talking about

24
00:01:09,090 --> 00:01:11,179
supermarkets_semi-colons,

25
00:01:11,204 --> 00:01:13,347
[No audio]

26
00:01:13,372 --> 00:01:20,752
supermarkets_semi-colons.txt.

27
00:01:21,545 --> 00:01:24,570
And yeah, let me try this as it is now. So if I

28
00:01:24,570 --> 00:01:26,610
execute that, Python will not be able to

29
00:01:26,610 --> 00:01:29,010
recognize the semicolon there. The

30
00:01:29,010 --> 00:01:30,521
reason for that is because

31
00:01:30,559 --> 00:01:32,940
[No audio]

32
00:01:32,965 --> 00:01:37,650
separator parameter has a value of comma by

33
00:01:37,650 --> 00:01:39,660
default, so you want to change that to

34
00:01:39,660 --> 00:01:42,090
your separator, which is a semicolon in

35
00:01:42,090 --> 00:01:46,085
this case, execute. We got an error

36
00:01:46,110 --> 00:01:47,730
there, unexpected keyword argument

37
00:01:47,730 --> 00:01:49,885
separator. So it seems like

38
00:01:49,910 --> 00:01:52,410
read_csv doesn't have a separated

39
00:01:52,800 --> 00:01:56,850
separator parameter. In that case, you

40
00:01:56,850 --> 00:02:03,810
want to help, ask for help, and so, and

41
00:02:03,810 --> 00:02:07,200
yeah, here is the parameters that you want

42
00:02:07,200 --> 00:02:10,770
to pass. So it's actually a sep and you

43
00:02:10,770 --> 00:02:12,900
can see that the default value of sep is

44
00:02:12,930 --> 00:02:17,850
a comma. So close that and go here,

45
00:02:18,065 --> 00:02:20,735
change that to sep, execute, and here is

46
00:02:20,760 --> 00:02:23,160
the DataFrame. Great. What's left to

47
00:02:23,160 --> 00:02:26,460
do? Yeah, we consumed everything, and that's

48
00:02:26,460 --> 00:02:28,980
about reading local files.

49
00:02:29,004 --> 00:02:31,004
[No audio]