InstaQB

Home
Institutions
- Institutions
  
  Polytechnic Colleges
  
  Medical Colleges
  
  Arts & Science Colleges
  
  Universities
  
  Engineering Colleges
  
  Agricultural Colleges
  
  Research Institute
  
  Law Colleges
  
  Audiology and Speech Colleges
  
  Business & Management colleges
  
  Nursing colleges
  
  Hotel Management institutes
  
  Aeronautical Colleges
  
  Bachelor's Degree
Syllabus
Courses
Stateboard
- 12th Standard English Medium
  
  Maths
  
  Physics
  
  Chemistry
  
  Biology
  
  Computer Science
  
  Business Maths
  
  Economics
  
  Commerce
  
  Accountancy
  
  History
  
  Computer Applications
  
  Computer Technology
  12th Standard Tamil Medium
  
  உயிரியல்
  
  கணினி பயன்பாடுகள்
  
  கணினி அறிவியல்
  
  வணிகக் கணிதம்
  
  வணிகவியல்
  
  பொருளியல்
  
  கணிதவியல்
  
  வேதியியல்
  
  இயற்பியல்
  
  கணினி தொழில்நுட்பம்
  
  வரலாறு
  
  கணக்குப்பதிவியல்
  11th Standard English Medium
  
  Maths
  
  Commerce
  
  Economics
  
  Biology
  
  Business Maths
  
  Accountancy
  
  Computer Science
  
  Physics
  
  Chemistry
  
  Computer Applications
  
  History
  
  Computer Technology
  
  Bio - Zoology
  11th Standard Tamil Medium
  
  கணிதவியல்
  
  உயிரியல்
  
  பொருளியல்
  
  இயற்பியல்
  
  வேதியியல்
  
  வணிகக் கணிதம்
  
  கணினி அறிவியல்
  
  கணக்குப்பதிவியல்
  
  வணிகவியல்
  
  கணினி பயன்பாடுகள்
  10th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  9th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  8th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  7th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
ICSE/ISC
- Class XII
  
  Mathematics
  
  Physics
  
  Accountancy
  
  Biology
  
  History
  
  Geography
  
  Psychology
  
  chemistry
  
  Economics
  
  Computer Science
  
  Political Science
  
  Business Studies
  Class XI
  
  Accountancy
  
  Chemistry
  
  Mathematics
  
  Biology
  
  Geography
  
  Physics
  
  History
CBSE
- 12Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Geography
  
  Socialogy
  
  Business Studies
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  
  Home Science
  11Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Socialogy
  
  Business Studies
  
  Geography
  
  Home Science
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  10Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  Mathematics
  
  Economics
  
  Geography
  
  History & Civics
  
  Computer Application
  9Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  mathematics
  
  Computer Application
  
  Economics
  
  Geography
  
  History & Civics

12th Computer Science Weekly Test - 2 ( Python and CSV files )

St. Britto Hr. Sec. School - Madurai

12th Computer Science Weekly Test - 2 ( Python and CSV files )-Aug 2020

Time : 1.30 Hours

Part - A

Multiple Choice Question - Answer All Question

The default file open mode is

rt
x
a
r

Which method will free up the resources that were tied with the file?

free ()
open ()
resources ()
close ()

Which of the following allows to create, store and re-use various formatting parameters for CSV file data?

class
dialect
object
none of these

Which of the following describes the format of the CSV file that is to be read?

parameter
dialect
whitespace
delimeter

The statement f = open (“sample.txt”) equivalent to the mode

r
x
x or a
r or r+

The function used to add elements to CSV file is

add ()
write ()
append ()
addition ()

Which python file modes are used to creating new file?

'w'
'x'
'a'
all of these

How many rows at a time the writerrow( ) method writes in a CSV file?

1
2
3
many

________has a garbage collector to clean up unreferenced objects.

CSV
Excel
Python
Open office

In Excel, the default CSV files should open automatically by

Singleclick
Right click
Double click
None of these

Which of the following can protect if the data itself contains commas in CSV file?

' '
,,
" "

Which python file mode open a file for exclusive creation?

'x'
'w'
't'
'a'

List literals are enclosed with

{ }
( )
< >
[ ]

_______command arranges a CSV file list value in ascending order.

listname.sort ()
listname.ascd ()
listname.asc ()
sorting ()

Which option allows to write the double quote or all the values in CSV file?

csv.Quote ()
csv.ALL_QUOTE()
csv.QUOTE_ALL ()
csv.QUOTEALL ()

Part - B

Generic 5 - Answer All Question

Write a program to read the CSV file and store it in a list.

Write a program to read the CSV file with user defined delimiter.

Write a program to read CSV file with a line Terminator.

Write a program to read the CSV file through python using reader () method.

Write a program to read a specific column in a CSV file.
Write a program to read the CSV file which contains spaces after the delimiter.

How will you sort more than one column in a CSV file? Explain with an example.

Differentiate Excel file and CSV file.

Comment

Add Comment

Tamilnadu Stateboardszs - Class