skill lync module 5 session 2 part 1 Pandas Functions Flashcards | StudBud

skill lync module 5 session 2 part 1 Pandas Functions

38 termsStudBud Administration21 plays

Test your knowledge on various functions in the Pandas library for data manipulation and analysis

Flashcards38 cardsFPractice quizPHost liveL

Questions 38

Answers

1
Which function writes to JSON?
read_csv()
to_json()
to_csv()
read_excel()
2
What is the output of read_json()?
DataFrame
Text file
CSV file
SQL table
3
What does df.to_excel() do?
Write CSV
Write Excel
Read CSV
Read Excel
4
True or false: pd.to_csv() reads CSV files
False
True
5
Which function is used for SQL queries?
to_sql()
connect()
read_sql()
read_json()
6
True or false: read_sql() reads from CSV
False
True
7
Which library provides connect() function?
numpy
sqlite3
matplotlib
pandas
8
What is pandas primarily used for?
Graphic design
Web design
Data analysis
Game development
9
Which function reads JSON into DataFrame?
read_sql()
to_sql()
to_json()
read_json()
10
What does pd.to_csv() do?
Write Excel
Read Excel
Write CSV
Read CSV
11
Which function reads SQL query into DataFrame?
to_sql()
read_sql()
read_json()
connect()
12
True or false: pandas can read JSON files
True
False
13
Which function writes to Excel?
read_csv()
df.to_excel()
read_excel()
to_csv()
14
What is the default format for to_sql()?
Oracle
SQLite
MySQL
PostgreSQL
15
What does read_json() do?
Reads JSON files
Writes SQL tables
Reads SQL tables
Writes JSON files
16
True or false: to_sql() writes data to SQL
False
True
17
What does read_json() do?
Read JSON
Read CSV
Write JSON
Write CSV
18
Which function writes DataFrame to SQL?
read_sql()
connect()
read_json()
to_sql()
19
Complete: pandas is a ___ library
machine learning
web development
networking
data analysis
20
Which function connects to SQLite?
db.connect()
sqlite3.connect()
pandas.connect()
sql.connect()
21
Which method writes DataFrame to JSON?
read_sql()
to_sql()
to_json()
read_json()
22
Which function reads a JSON file?
read_csv()
read_excel()
to_csv()
read_json()
23
Which function writes to a CSV file?
to_json()
read_excel()
to_csv()
read_csv()
24
Which function writes to a CSV file?
read_csv()
to_json()
to_csv()
read_excel()
25
What does read_sql() return?
CSV file
JSON object
SQL table
DataFrame
26
Which function reads a CSV file?
read_csv()
read_excel()
to_csv()
to_json()
27
What does to_json() do?
Write CSV
Read CSV
Read JSON
Write JSON
28
True or false: read_excel() writes Excel files
False
True
29
What does read_excel() do?
Write Excel
Read CSV
Read Excel
Write CSV
30
What does sqlite3.connect() return?
JSON object
Connection object
DataFrame
SQL table
31
Which method saves DataFrame to SQL?
read_json()
to_json()
read_sql()
to_sql()
32
Which function reads an Excel file?
read_excel()
to_json()
read_csv()
to_csv()
33
What does pd.to_csv() return?
DataFrame
Excel file
JSON file
CSV file
34
How to connect to SQLite database?
db.connect()
pandas.connect()
sqlite3.connect()
sql.connect()
35
Which function reads an Excel file?
read_csv()
to_csv()
to_json()
read_excel()
36
What does df.to_json() do?
Read JSON
Write JSON
Read CSV
Write CSV
37
True or false: read_csv() reads a CSV file
False
True
38
What does read_csv() do?
Write CSV
Write Excel
Read CSV
Read Excel