Reading Excel files (read_excel) in Data Analysis Python - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to read an Excel file named 'data.xlsx' into a DataFrame.

Data Analysis Python

import pandas as pd

df = pd.[1]('data.xlsx')

Drag options to blanks, or click blank then click option'

Aread_excel

Bread_json

Cread_csv

Dread_table

Attempts:

3 left

💡 Hint

Common Mistakes

Using read_csv instead of read_excel

Forgetting to import pandas

Misspelling the function name

The read_excel function from pandas reads Excel files into DataFrames.

2fill in blank

medium

Complete the code to read the Excel file 'data.xlsx' and load only the sheet named 'Sales'.

Data Analysis Python

import pandas as pd

df = pd.read_excel('data.xlsx', sheet_name=[1])

Drag options to blanks, or click blank then click option'

A'Sales'

BNone

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using an integer index instead of the sheet name

Not using quotes around the sheet name

Passing None which reads all sheets

To read a specific sheet by name, set sheet_name to the sheet's name as a string.

3fill in blank

hard

Fix the error in the code to read an Excel file with pandas.

Data Analysis Python

import pandas as pd

df = pd.read_excel('data.xlsx', [1]='Sales')

Drag options to blanks, or click blank then click option'

Asheetname

Bsheet_name

Csheet

Dsheetnamee

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'sheetname' without underscore

Misspelling the parameter name

Using an invalid parameter

The correct parameter name is sheet_name with an underscore.

4fill in blank

hard

Fill both blanks to read only columns 'A' and 'C' from the Excel sheet named 'Data'.

Data Analysis Python

import pandas as pd

df = pd.read_excel('file.xlsx', sheet_name=[1], usecols=[2])

Drag options to blanks, or click blank then click option'

A'Data'

B'Sales'

C['A', 'C']

D['B', 'D']

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong sheet name

Passing columns as a string instead of a list

Using incorrect column letters

Set sheet_name to 'Data' and usecols to the list of columns ['A', 'C'] to read only those columns.

5fill in blank

hard

Fill all three blanks to read the Excel file 'report.xlsx', load sheet 'Summary', and skip the first 2 rows.

Data Analysis Python

import pandas as pd

df = pd.read_excel([1], sheet_name=[2], skiprows=[3])

Drag options to blanks, or click blank then click option'

A'report.xlsx'

B'Summary'

C2

D'Data'

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the filename or sheet name

Passing skiprows as a string instead of an integer

Using wrong sheet name

Pass the filename as a string, the sheet name as 'Summary', and set skiprows to 2 to skip the first two rows.