Python to Access Data Quiz

What does the open() function do in Python?

• Reads or writes a file
• Imports a module
• Declares a variable
• Runs a loop

Which of the following are common file extensions for flat files?

• .csv
• .txt
• .doc
• .pdf

Which library should you use in Python to read and write JSON files?

• pandas
• json
• requests
• openpyxl

What type of object is created when loading a JSON file into Python?

• List
• Dictionary
• DataFrame
• Series

What does the read_csv() function return in pandas?

• List
• Series
• DataFrame
• Dictionary

Which formats can pandas handle directly for reading and writing?

• CSV
• Excel
• HTML
• TXT

What does SQLAlchemy primarily help with?

• Web development
• Front-end styling
• Managing database connections
• Data visualization

Which of the following are typical components in a SQLAlchemy connection string?

• Driver
• Username
• Password
• Chart type

Which Python function loads SQL query results directly into a DataFrame?

• pd.read_sql()
• pd.to_sql()
• con.execute()
• pd.load_sql()

Google Colab already has your _______ for BigQuery.