17724937
Description
Quiz by Maggie Samson, updated more than 1 year ago
|
Created by Maggie Samson
over 5 years ago
|
|
Question 1
Question
What does CSV stand for?
Answer
-
Comma Separated Values
-
Cell Separated Values
-
Comma Separation Values
-
Cell Separation Values
Question 2
Question
The csv module is a standard Python library and no separate installation is needed.
Answer
- True
- False
Question 3
Question
Consider the following code:
import csv
csvfile = open('test.csv', "rb")
reader = csv.reader(cvsfile)
What does the csv.reader function accomplish?
Answer
-
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.
Question 4
Question
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?
Answer
-
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
Question 5
Question
Which module is used for writing data and formatting information to older Excel files, i.e. .xls files before Excel 2010?
Answer
-
xlrd
-
openpyxl
-
xlsxwriter
-
xlwt
Question 6
Question
The openpyxl module can be used to work with both .xls as well as .xlsx files.
Answer
- True
- False
Question 7
Question
How would you determine the number of rows and columns with data values in an Excel file using the xlrd module?
Answer
-
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
Question 8
Question
Consider the following code:
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?
Answer
-
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()
Question 9
Question
Which of the following is not a cell type for Excel data in the xlrd module?
Answer
-
Text
-
Integer
-
Date
-
Boolean
-
Blank
-
Error
Question 10
Question
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?
Answer
-
print book.sheetnames
-
for sheet in book: print book.sheet.name
-
for sheet in book.sheets(): print sheet.name
-
print book.sheet.name()
Want to create your own Quizzes for free with GoConqr? Learn more.