pandas Reading files into pandas DataFrame Read table into DataFrame
Example
Table file with header, footer, row names, and index column:
file: table.txt
This is a header that discusses the table file
to show space in a generic table file
index name occupation
1 Alice Salesman
2 Bob Engineer
3 Charlie Janitor
This is a footer because your boss does not understand data files
code:
import pandas as pd
# index_col=0 tells pandas that column 0 is the index and not data
pd.read_table('table.txt', delim_whitespace=True, skiprows=3, skipfooter=2, index_col=0)
output:
name occupation
index
1 Alice Salesman
2 Bob Engineer
3 Charlie Janitor
Table file without row names or index:
file: table.txt
Alice Salesman
Bob Engineer
Charlie Janitor
code:
import pandas as pd
pd.read_table('table.txt', delim_whitespace=True, names=['name','occupation'])
output:
name occupation
0 Alice Salesman
1 Bob Engineer
2 Charlie Janitor
All options can be found in the pandas documentation here
