Loading CSV and Excel files in LangChain - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What does this Langchain CSV loader output?

Given the following Langchain code snippet that loads a CSV file, what will be the output type of documents?

LangChain

from langchain.document_loaders import CSVLoader
loader = CSVLoader(file_path='data/sample.csv')
documents = loader.load()

A A list of Document objects representing each row in the CSV

B A single string containing the entire CSV content

C A dictionary with keys as column names and values as lists of column data

D A pandas DataFrame object

💡 Hint

Think about what Langchain loaders usually return after loading files.

Langchain's CSVLoader returns a list of Document objects, each representing a row or chunk of the CSV file, not raw strings or dataframes.

📝 Syntax

intermediate

Identify the syntax error in this Excel loader code

Which option contains a syntax error when trying to load an Excel file using Langchain's ExcelLoader?

LangChain

from langchain.document_loaders import ExcelLoader
loader = ExcelLoader(file_path='data/sample.xlsx')
documents = loader.load()

A loader = ExcelLoader(file='data/sample.xlsx')

B loader = ExcelLoader('data/sample.xlsx')

C loader = ExcelLoader(file_path='data/sample.xlsx', sheet_name='Sheet1')

D loader = ExcelLoader(file_path='data/sample.xlsx')

💡 Hint

Check the parameter names expected by ExcelLoader constructor.

ExcelLoader expects the parameter file_path, not file. Option A uses an invalid parameter name causing a TypeError.

❓ state_output

advanced

What is the number of documents loaded from a multi-sheet Excel file?

Consider this code loading an Excel file with 3 sheets, each having 5 rows. What is the length of documents after loading all sheets?

LangChain

from langchain.document_loaders import ExcelLoader
loader = ExcelLoader(file_path='data/multi_sheet.xlsx', sheet_name=None)
documents = loader.load()

A 5

B 3

C 1

D 15

💡 Hint

When sheet_name=None, all sheets are loaded and combined.

Setting sheet_name=None loads all sheets. Each sheet has 5 rows, so total documents = 3 sheets * 5 rows = 15.

🔧 Debug

advanced

Why does this CSVLoader code raise a FileNotFoundError?

This code raises a FileNotFoundError. What is the most likely cause?

LangChain

from langchain.document_loaders import CSVLoader
loader = CSVLoader(file_path='data/missing.csv')
documents = loader.load()

A The CSV file is empty, causing the loader to fail

B CSVLoader requires an absolute file path, relative paths cause errors

C The file path 'data/missing.csv' does not exist in the project directory

D The CSVLoader class is deprecated and cannot load files

💡 Hint

Check if the file path is correct and the file exists.

FileNotFoundError means the file path given does not point to an existing file. Relative paths are allowed and empty files do not cause this error.

🧠 Conceptual

expert

Which option best describes how Langchain handles Excel sheets when loading?

When using Langchain's ExcelLoader with sheet_name=None, how does it process the Excel file?

A It loads sheets one by one but requires manual calls for each sheet

B It loads all sheets and returns a combined list of Document objects for every row in all sheets

C It loads all sheets but returns a dictionary with sheet names as keys and Document lists as values

D It loads only the first sheet and ignores the rest

💡 Hint

Think about how Langchain simplifies multi-sheet Excel loading.

Langchain's ExcelLoader with sheet_name=None loads all sheets and merges their rows into a single list of Document objects.

Practice

1. What is the main purpose of using CSVLoader in LangChain?

easy

A. To load CSV files and convert their data into documents LangChain can process

B. To save data into CSV files from LangChain documents

C. To visualize CSV data in charts

D. To convert Excel files into CSV format

Solution

1. Step 1: Understand CSVLoader's role

   CSVLoader is designed to read CSV files and transform their content into a format LangChain can use.

2. Step 2: Differentiate from other options

   Saving, visualizing, or converting files are not functions of CSVLoader.

3. Final Answer:

   To load CSV files and convert their data into documents LangChain can process -> Option A

4. Quick Check:

   CSVLoader loads CSV files = A [OK]

Hint: CSVLoader reads CSV files into LangChain documents [OK]

Common Mistakes:

• Thinking CSVLoader saves or visualizes data
• Confusing CSVLoader with ExcelLoader
• Assuming CSVLoader converts file formats

2. Which of the following is the correct way to load an Excel file named data.xlsx using LangChain's ExcelLoader?

easy

A. loader = ExcelLoader.open('data.xlsx')

B. loader = ExcelLoader.load('data.xlsx')

C. loader = ExcelLoader.read('data.xlsx')

D. loader = ExcelLoader('data.xlsx')

Solution

1. Step 1: Recall ExcelLoader instantiation

   ExcelLoader is instantiated by passing the file path as a string to its constructor.

2. Step 2: Identify correct syntax

   Only ExcelLoader('data.xlsx') correctly creates a loader instance; other methods like load(), read(), open() are invalid here.

3. Final Answer:

   loader = ExcelLoader('data.xlsx') -> Option D

4. Quick Check:

   Use constructor with filename = A [OK]

Hint: Use ExcelLoader('filename.xlsx') to create loader [OK]

Common Mistakes:

• Using non-existent methods like load() or read() on ExcelLoader
• Forgetting to pass filename as a string
• Trying to open file with open() method on loader

3. Given the code:

from langchain.document_loaders import CSVLoader
loader = CSVLoader('contacts.csv')
docs = loader.load()

What will docs contain after running this code?

medium

A. A dictionary mapping column names to values

B. A list of document objects representing rows from the CSV file

C. An error because CSVLoader requires sheet name

D. A single string with all CSV content

Solution

1. Step 1: Understand CSVLoader.load() output

   The load() method returns a list of document objects, each representing a row or chunk from the CSV file.

2. Step 2: Eliminate incorrect options

   It does not return a single string, dictionary, or error for missing sheet name (sheet names apply to ExcelLoader).

3. Final Answer:

   A list of document objects representing rows from the CSV file -> Option B

4. Quick Check:

   load() returns list of documents = D [OK]

Hint: load() returns list of documents, not raw strings [OK]

Common Mistakes:

• Expecting a string or dictionary instead of documents list
• Confusing CSVLoader with ExcelLoader sheet requirements
• Assuming load() returns raw file content

4. What is wrong with this code snippet for loading an Excel file?

from langchain.document_loaders import ExcelLoader
loader = ExcelLoader('data.xlsx', sheet_name='Sheet1')
docs = loader.load()

medium

A. The file path must be an absolute path, not relative

B. ExcelLoader does not accept sheet names when loading files

C. The parameter should be named sheet_names (plural), not sheet_name

D. The load() method must be called with the sheet name argument

Solution

1. Step 1: Check ExcelLoader sheet name parameter

   ExcelLoader expects the parameter sheet_names (plural) as a list of sheet names, not sheet_name.

2. Step 2: Validate other options

   ExcelLoader does accept sheet names, relative paths are allowed, and load() does not take sheet name arguments.

3. Final Answer:

   The parameter should be named sheet_names (plural), not sheet_name -> Option C

4. Quick Check:

   Use sheet_names list parameter = C [OK]

Hint: Use sheet_names=['Sheet1'] not sheet_name='Sheet1' [OK]

Common Mistakes:

• Using singular sheet_name instead of plural sheet_names
• Thinking load() needs sheet name argument
• Believing relative paths are invalid

5. You want to load only the 'Sales' sheet from an Excel file report.xlsx using LangChain. Which code snippet correctly does this?

hard

A. loader = ExcelLoader('report.xlsx', sheet_names=['Sales'])
docs = loader.load()

B. loader = ExcelLoader('report.xlsx', sheet_name='Sales')
docs = loader.load()

C. loader = ExcelLoader('report.xlsx')
docs = loader.load(sheet_name='Sales')

D. loader = ExcelLoader('report.xlsx')
docs = loader.load()
filter_docs = [d for d in docs if d.metadata['sheet'] == 'Sales']

Solution

1. Step 1: Use correct parameter to specify sheets

   ExcelLoader accepts sheet_names as a list of sheet names to load only those sheets.

2. Step 2: Confirm load() usage

   load() does not take sheet names; they must be specified when creating the loader.

3. Step 3: Evaluate options

   loader = ExcelLoader('report.xlsx', sheet_name='Sales') docs = loader.load() uses sheet_name (singular), incorrect. loader = ExcelLoader('report.xlsx') docs = loader.load(sheet_name='Sales') passes sheet name to load(), invalid. loader = ExcelLoader('report.xlsx') docs = loader.load() filter_docs = [d for d in docs if d.metadata['sheet'] == 'Sales'] loads all sheets then filters manually, inefficient. Only loader = ExcelLoader('report.xlsx', sheet_names=['Sales']) docs = loader.load() correctly uses sheet_names=['Sales'] at loader creation.

4. Final Answer:

   loader = ExcelLoader('report.xlsx', sheet_names=['Sales']) docs = loader.load() -> Option A

5. Quick Check:

   Use sheet_names list at loader creation = B [OK]

Hint: Pass sheet_names=['SheetName'] when creating ExcelLoader [OK]

Common Mistakes:

• Using singular sheet_name parameter
• Passing sheet name to load() method
• Loading all sheets then filtering manually