Basics

Question 1

How do you import a CSV and convert it to a list of lists?

Answer 1

opened_file = open (“hacker_news.csv”)
from csv import reader
read_file = reader(opened_file)
hn= list(read_file)

Question 2

How do you display the first five rows of a list of lists which name is “hn”?

Answer 2

print(hn[:5])

Question 3

How do you import reader?

Answer 3

from csv import reader

Question 4

How do you import a CSV file?

Answer 4

opened_file= open(“AppleStore.csv”)

Question 5

How do you round a variable called “variable_a”?

Answer 5

round(variable_a)

Question 6

row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]

Assign the fourth element from the list row_1 to a variable named ratings_1.

Answer 6

ratings_1 = (row_1[3])

Question 7

Assign the last element from the list row_1 to a variable named rating_1. Try to take advantage of negative indexing

row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]

Answer 7

rating_1 = (row_1[-1])

Question 8

Add the three ratings together and save the sum to a variable named total_rating

rating_1 = (row_1[-1])
rating_2 = (row_2[-1])
rating_3 = (row_3[-1])

Answer 8

total_rating = (rating_1 + rating_2 +rating_3)

Question 9

Display the lenght of a list of lists called apps_data

Answer 9

print(len(apps_data))

Question 10

Display the header row of a list of lists called apps_data

Answer 10

print(apps_data[0])

Question 11

First four elements of the following list:

row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]

Answer 11

row_1[:4]

Question 12

Last 3 elements of the following list:

row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]

Answer 12

row_1[-3:]

Question 13

Select the list slice [‘USD’, 1126879] from the following list:

row_5 = [‘Pandora - Music & Radio’, 0.0, ‘USD’, 1126879, 4.0]

Answer 13

row_5[2:4]

Question 14

What is the first step when converting a CSV into a lists of lists?

Answer 14

opened_file = open (“hacker_news.csv”)

Question 15

What is the second step when converting a CSV into a list of lists?

Answer 15

read_file = reader(opened_file)

Question 16

What is the last step when converting a CSV into a list o lists?

Answer 16

hn= list(read_file)

Question 17

Create a list of lists with the following:

row_1 = ['Facebook', 0.0, 'USD', 2974676, 3.5]
row_2 = ['Instagram', 0.0, 'USD', 2161558, 4.5]
row_3 = ['Clash of Clans', 0.0, 'USD', 2130805, 4.5]
row_4 = ['Temple Run', 0.0, 'USD', 1724546, 4.5]
row_5 = ['Pandora - Music & Radio', 0.0, 'USD', 1126879, 4.0]

Answer 17

app_data_set = [row_1, row_2, row_3, row_4, row_5]

Question 18

From apps_data_set select row_1 and its last element and name it fb_rating.

row_1 = ['Facebook', 0.0, 'USD', 2974676, 3.5]
row_2 = ['Instagram', 0.0, 'USD', 2161558, 4.5]
row_3 = ['Clash of Clans', 0.0, 'USD', 2130805, 4.5]
row_4 = ['Temple Run', 0.0, 'USD', 1724546, 4.5]
row_5 = ['Pandora - Music & Radio', 0.0, 'USD', 1126879, 4.0]

app_data_set = [row_1, row_2, row_3, row_4, row_5]

Answer 18

fb_rating = app_data_set[0][4]

Question 19

From apps_data_set select row_4 and its last element and name it TR_rating.

row_1 = ['Facebook', 0.0, 'USD', 2974676, 3.5]
row_2 = ['Instagram', 0.0, 'USD', 2161558, 4.5]
row_3 = ['Clash of Clans', 0.0, 'USD', 2130805, 4.5]
row_4 = ['Temple Run', 0.0, 'USD', 1724546, 4.5]
row_5 = ['Pandora - Music & Radio', 0.0, 'USD', 1126879, 4.0]

app_data_set = [row_1, row_2, row_3, row_4, row_5]

Answer 19

TR_rating =app_data_set[3][4]

Question 20

What is the first line when starting a new loop on app_data_set?

Answer 20

for element in app_data_set:

Question 21

Assign the headers of data set hn to a varable called headers

Answer 21

headers = hn[0]

Question 22

Display a blank space

Answer 22

print(‘\n’)

Question 23

Remove the header row from a data set called hn

Answer 23

hn= hn[1:]