17724937
Descrição
Quiz por Maggie Samson, atualizado more than 1 year ago
|
Criado por Maggie Samson
mais de 5 anos atrás
|
|
Questão 1
Questão
What does CSV stand for?
Responda
-
Comma Separated Values
-
Cell Separated Values
-
Comma Separation Values
-
Cell Separation Values
Questão 2
Questão
The csv module is a standard Python library and no separate installation is needed.
Responda
- True
- False
Questão 3
Questão
Consider the following code:
import csv
csvfile = open('test.csv', "rb")
reader = csv.reader(cvsfile)
What does the csv.reader function accomplish?
Responda
-
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.
Questão 4
Questão
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?
Responda
-
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
Questão 5
Questão
Which module is used for writing data and formatting information to older Excel files, i.e. .xls files before Excel 2010?
Responda
-
xlrd
-
openpyxl
-
xlsxwriter
-
xlwt
Questão 6
Questão
The openpyxl module can be used to work with both .xls as well as .xlsx files.
Responda
- True
- False
Questão 7
Questão
How would you determine the number of rows and columns with data values in an Excel file using the xlrd module?
Responda
-
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
Questão 8
Questão
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?
Responda
-
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()
Questão 9
Questão
Which of the following is not a cell type for Excel data in the xlrd module?
Responda
-
Text
-
Integer
-
Date
-
Boolean
-
Blank
-
Error
Questão 10
Questão
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?
Responda
-
print book.sheetnames
-
for sheet in book: print book.sheet.name
-
for sheet in book.sheets(): print sheet.name
-
print book.sheet.name()
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.