What does CSV stand for?
Comma Separated Values
Cell Separated Values
Comma Separation Values
Cell Separation Values
The csv module is a standard Python library and no separate installation is needed.
Consider the following code:
import csv csvfile = open('test.csv', "rb") reader = csv.reader(cvsfile)
What does the csv.reader function accomplish?
Each row read from the csv file is returned as a single string.
Each row read from the csv file is returned as a list of cell objects, each with their own data type.
All the rows from the csv file combined are returned as a single list of strings.
Each row read from the csv file is returned as a list of strings.
Let's say a CSV file contains a header row, i.e. the first row contains the names of the fields. How would you make sure to skip the header when reading the actual data values?
Set the header property to True
Read the CSV file row by row, but skip any row that start with text instead of a numerical value
Read the CSV file row by row, but start at the 2nd row
Use the header function of the csv module
Which module is used for writing data and formatting information to older Excel files, i.e. .xls files before Excel 2010?
xlrd
openpyxl
xlsxwriter
xlwt
The openpyxl module can be used to work with both .xls as well as .xlsx files.
How would you determine the number of rows and columns with data values in an Excel file using the xlrd module?
use the nrows and ncols properties of the Sheet object
read data values until you encounter a row or column with only empty string values
read the number of rows and columns from the header file
use the row_values and col_values functions
import xlrd book = xlrd.open_workbook("C:/Temp/Myfile.xlsx") sheet = book.sheet_by_index(0)
How would you print all data values in the worksheet, one by one?
for i in range(sheet.nrows): print sheet.row_values(i)
for i in range(sheet.nrows): print sheet.row(i)
print sheet.row()
print sheet.row_values()
Which of the following is not a cell type for Excel data in the xlrd module?
Text
Integer
Date
Boolean
Blank
Error
Consider an Excel file with multiple worksheets and the following code:
import xlrd book = xlrd.open_workbook("C:/Project/Data.xls")
How would you print the name of each worksheet?
print book.sheetnames
for sheet in book: print book.sheet.name
for sheet in book.sheets(): print sheet.name
print book.sheet.name()
