Read CSV - PANDAS Read CSV

Question 1

Read CSV Files - A simple way to store big data sets is to use CSV files (comma separated files).

Answer 1

Read CSV Files

Question 2

CSV files contains plain text and is a well know format that can be read by everyone including Pandas.

Answer 2

Read CSV Files

Question 3

Use to_string() to print the entire DataFrame.

Answer 3

Read CSV Files

Question 4

If you have a large DataFrame with many rows, Pandas will only return the first 5 rows, and the last 5 rows:

Answer 4

Read CSV Files

Question 5

MAX_ROWS - The number of rows returned is defined in Pandas option settings.

Answer 5

Read CSV Files

Question 6

You can check your system’s maximum rows with the pd.options.display.max_rows statement.

Answer 6

Read CSV Files

Question 7

If DataFrame contains more than 60 rows, the print(df) statement will return only the headers and the first and last 5 rows.

Answer 7

Read CSV Files

Question 8

You can change the maximum rows number with the same statement.

Answer 8

print(pd.options.display.max_rows)

Question 9

Increase the maximum number of rows to display the entire DataFrame:

Answer 9

pd.options.display.max_rows = 9999

Question 10

Exercise - CSV is short for:

Answer 10

Comma Separated Values

Question 11

What is a correct syntax for loading a .csv file into a DataFrame?

Answer 11

df = pd.read_csv(‘data.csv’)

Question 12

By default, if you print a large DataFrame with the print(df) function, Pandas will only return a selection of the data. How many rows will be returned?

Answer 12

10, the headers and the first and last 5 rows