We can also ignore headers in the csv file and give our own custom column names by passing names parameter to the function. # read CSV with different headerĭf = pd.read_csv( './data/the_office/the_office_lines.csv', header= 1) We can change that by passing the header parameter.
Standard encodings supported by Python can be found here # read CSV with encodingĭf = pd.read_csv( './data/the_office/the_office_lines.csv', encoding= 'utf-8')īy default first row is treated as column header or column names for the data frame. We can pass encoding parameter to open files with different encodings. # print the first 5 rows of the dataframe # read CSV file df = pd.read_csv( './data/the_office/the_office_lines.csv') Reading CSV files is the easiest we can just use the read_csv method. We going to cover reading csv, tsv, json and excel files.
This can be done by querying databases, making server requests and most commonly by reading data files. The first step into any Exploratory Data Analysis is to read data into the memory. All the data files using in this blog are here and the Jupyter Notebook is here. I've converted CSV to other formats to cover different scenarios. We are going to use The Office data set from Kaggle as an example. This article assumes you have basic knowledge of Python and have a working dev environment setup.
0 kommentar(er)
