TXT Files
Text files are another common data format, and the pandas library makes it easy to work with them — often more straightforward than using traditional methods. To read text files, you'll often use the same function, pd.read_csv()
. However, to ensure the text file is read correctly, it's essential to use an additional parameter called sep
, which stands for separator or delimiter in the text. Here's an example:
If your text file doesn't have a header row containing column names, set the header
parameter to None
. Doing so informs pandas not to treat the first row as column names.
Note
To specify a new line as the separator, use the code:
sep='\r'
where'\r'
represents the carriage return.
Let's put this into practice!
Tarefa
- Read the TXT file into a DataFrame (use the link below as the first argument of the function).
- Display the output on your screen.
You can access the TXT file by clicking on the following link: Link to file
The actual link: https://codefinity-content-media.s3.eu-west-1.amazonaws.com/a43d24b6-df61-4e11-9c90-5b36552b3437/pandas.txt
Tudo estava claro?
Conteúdo do Curso
Pandas First Steps
2. Reading Files in Pandas
3. Analyzing the Data
Pandas First Steps
TXT Files
Text files are another common data format, and the pandas library makes it easy to work with them — often more straightforward than using traditional methods. To read text files, you'll often use the same function, pd.read_csv()
. However, to ensure the text file is read correctly, it's essential to use an additional parameter called sep
, which stands for separator or delimiter in the text. Here's an example:
If your text file doesn't have a header row containing column names, set the header
parameter to None
. Doing so informs pandas not to treat the first row as column names.
Note
To specify a new line as the separator, use the code:
sep='\r'
where'\r'
represents the carriage return.
Let's put this into practice!
Tarefa
- Read the TXT file into a DataFrame (use the link below as the first argument of the function).
- Display the output on your screen.
You can access the TXT file by clicking on the following link: Link to file
The actual link: https://codefinity-content-media.s3.eu-west-1.amazonaws.com/a43d24b6-df61-4e11-9c90-5b36552b3437/pandas.txt
Tudo estava claro?