Analytics - Lesson 2 - Accessing Data

What type of files can be used to store data after the program finishes?

• Image files

• Excel files

• CSV files

• Text files

Answer explanation

Text files are the type of files that can be used to store data after the program finishes, making them the correct choice.

What does the .txt extension indicate for a file?

• Text file

• Executable file

• Image file

• Audio file

Answer explanation

The .txt extension indicates a Text file. It is commonly used for files containing plain text data.

What is the purpose of a delimiter in CSV files?

• To hide data

• To separate items

• To encrypt data

• To compress files

Answer explanation

The purpose of a delimiter in CSV files is to separate items, making it easier to parse and read the data within the file.

Which function is used to separate a string into a list based on a specified delimiter in Python?

• slice()

• split()

• join()

• concat()

Answer explanation

The 'split()' function is used to separate a string into a list based on a specified delimiter in Python, making it the correct choice for this question.

What is the benefit of using list comprehension in Python?

• It is more memory-intensive

• It is slower than loops

• It is concise and efficient

• It is more complex to implement

Answer explanation

List comprehension in Python is concise and efficient, making code more readable and reducing the number of lines needed compared to traditional loops.

What is the purpose of a CSV file?

• To store images

• To store numerical data

• To store audio files

• To store videos

Answer explanation

CSV files are used to store numerical data in a structured format, making it easy to organize and analyze data in spreadsheet applications.

What does the 'w' argument in the open() function indicate?

• Read from the file

• Write to the file

• Append to the file

• Close the file

Answer explanation

The 'w' argument in the open() function indicates writing to the file, allowing you to create or overwrite the contents of the file.

What is the maximum number of rows in an Excel file?

• 1,000 rows

• 1,048,576 rows

• 10,000 rows

• 100,000 rows

Answer explanation

The correct answer is 1,048,576 rows, which is the maximum number of rows in an Excel file. Excel supports up to 1,048,576 rows in a single worksheet.

What does the .csv extension indicate for a file?

• Text file

• Image file

• Excel file

• CSV file

Answer explanation

The .csv extension indicates that the file is a CSV (Comma-Separated Values) file, used for storing tabular data in plain text format.

What is the purpose of a text file?

• To store text only

• To store images

• To store videos

• To store audio files

Answer explanation

The purpose of a text file is to store text only, making the correct answer choice 'To store text only'. Text files do not store images, videos, or audio files.