17724937
Descripción
Test por Maggie Samson, actualizado hace más de 1 año
|
Creado por Maggie Samson
hace más de 5 años
|
|
Pregunta 1
Pregunta
What does CSV stand for?
Respuesta
-
Comma Separated Values
-
Cell Separated Values
-
Comma Separation Values
-
Cell Separation Values
Pregunta 2
Pregunta
The csv module is a standard Python library and no separate installation is needed.
Respuesta
- True
- False
Pregunta 3
Pregunta
Consider the following code:
import csv
csvfile = open('test.csv', "rb")
reader = csv.reader(cvsfile)
What does the csv.reader function accomplish?
Respuesta
-
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.
Pregunta 4
Pregunta
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?
Respuesta
-
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
Pregunta 5
Pregunta
Which module is used for writing data and formatting information to older Excel files, i.e. .xls files before Excel 2010?
Respuesta
-
xlrd
-
openpyxl
-
xlsxwriter
-
xlwt
Pregunta 6
Pregunta
The openpyxl module can be used to work with both .xls as well as .xlsx files.
Respuesta
- True
- False
Pregunta 7
Pregunta
How would you determine the number of rows and columns with data values in an Excel file using the xlrd module?
Respuesta
-
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
Pregunta 8
Pregunta
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?
Respuesta
-
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()
Pregunta 9
Pregunta
Which of the following is not a cell type for Excel data in the xlrd module?
Respuesta
-
Text
-
Integer
-
Date
-
Boolean
-
Blank
-
Error
Pregunta 10
Pregunta
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?
Respuesta
-
print book.sheetnames
-
for sheet in book: print book.sheet.name
-
for sheet in book.sheets(): print sheet.name
-
print book.sheet.name()
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.