1
00:00:00,870 --> 00:00:03,330
Let's move on with the TXT file.

2
00:00:03,350 --> 00:00:07,790
So it's a supermarkets separated by commas.

3
00:00:07,890 --> 00:00:11,870
So it's a structure separated by commas for that.

4
00:00:11,910 --> 00:00:20,730
So for TXT files separated by commas again you use read csv.

5
00:00:27,090 --> 00:00:27,820
Just like that.

6
00:00:27,830 --> 00:00:33,040
Df4 and here is the data frame,

7
00:00:33,100 --> 00:00:35,250
so this supermarkets.csv

8
00:00:35,250 --> 00:00:40,410
actually some say it's a comma separated file but but to be more accurate you would say character

9
00:00:40,410 --> 00:00:43,840
separated values so c for character.

10
00:00:44,190 --> 00:00:44,510
Yeah.

11
00:00:44,540 --> 00:00:46,610
There might be different characters there.

12
00:00:46,710 --> 00:00:53,710
In this case when you have commas as separators you don't have to pass any separate parameter here.

13
00:00:54,120 --> 00:00:58,710
But when you have other values and separators you will have to pass that.

14
00:00:58,770 --> 00:01:01,680
That is the next scenario.

15
00:01:01,820 --> 00:01:02,480
So df5

16
00:01:02,520 --> 00:01:06,880
pandas.read_csv.

17
00:01:07,440 --> 00:01:16,460
So we're talking about supermarkets semicolons super markets.

18
00:01:16,860 --> 00:01:20,830
semi-colons.txt.

19
00:01:22,050 --> 00:01:22,270
Yeah.

20
00:01:22,280 --> 00:01:24,220
Let me try this as it is now.

21
00:01:24,240 --> 00:01:28,260
So if I execute that python will not be able to recognize the semi-colon there.

22
00:01:28,710 --> 00:01:38,380
The reason for that is because separater parameter has a value of comma by default.

23
00:01:38,400 --> 00:01:42,030
So you want to change that to your separator which is a semicolon.

24
00:01:42,030 --> 00:01:45,010
In this case, execute.

25
00:01:45,570 --> 00:01:46,400
We got an error there.

26
00:01:46,430 --> 00:01:48,470
Unexpected keyword arguments separator.

27
00:01:48,510 --> 00:01:56,070
So it seems like read underscore csv doesn't have a separated separator parameter, in that case

28
00:01:56,650 --> 00:02:02,880
you want to do, to ask for help, so...

29
00:02:03,180 --> 00:02:07,920
And yeah, here is the parameters that you want to pass.

30
00:02:08,700 --> 00:02:17,320
So it's actually a sep and you can see that the default value of sep is a comma, so close that and go

31
00:02:17,320 --> 00:02:20,190
here, change that to sep, execute.

32
00:02:20,220 --> 00:02:21,840
And here is the data frame.

33
00:02:21,930 --> 00:02:22,380
Great.

34
00:02:22,470 --> 00:02:24,080
What's left to do.

35
00:02:24,080 --> 00:02:24,410
Oh yeah.

36
00:02:24,520 --> 00:02:28,950
We consumed everything, and that's about reading local files.