Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
2. CSV files
What DataFrames are
DataFrame columns
DataFrame rows
Filtering rows and columns
Filtering data frames
Sorting rows


Good. From now on, we will be using CSV files as our data sources. CSV files are simple text files that can store tabular data (similar to Excel spreadsheets). For instance, if you have the following table:

Full Name Age Nationality
Mark Smith 28 British
Jan Nowak 37 Polish
Oda Nobunaga 62 Japanese
Frank Johnson 19 American

Its CSV counterpart would look like:

Full Name,Age,Nationality
Mark Smith,28,British
Jan Nowak,37,Polish
Oda Nobunaga,62,Japanese
Frank Johnson,19,American

As you can see, a CSV stands for comma-separated values (hence the name). The first row typically stores column names (although it may be omitted). Subsequent rows store values. Instead of commas, other text delimiters may be used, such as semicolons (;).


Click Next exercise to continue.