Python - Data Science

Question 1

Name 3 libraries & their uses.

Answer 1

Numpy = lower level computation

Pandas = built atop numpy, used for data analysis

Scikit-Learn = use ML models

Question 2

pd.read_csv(filename)

Answer 2

imports data from CSV file

Question 3

pd.read_table(filename)

Answer 3

imports data from a delimited text file (like TSV)

Question 4

pd.read_excel(filename)

Answer 4

imports data from an Excel file

Question 5

pd.read_sql(query, connection_object)

Answer 5

reads from an SQL table/database

Question 6

pd.read_json(json_string)

Answer 6

reads from a JSON formatted string, URL, or file

Question 7

pd.read_html(url)

Answer 7

parses an html URL, string, or file and extracts tables to a list in a dataframe

Question 8

pd.read_clipboard()

Answer 8

takes the contents of your clipboard and passes it to read_table()

Question 9

pd.DataFrame(dict)

Answer 9

from a dict, keys for column names, values for data as lists

Question 10

df.shape()

Answer 10

prints the numbers of rows and columns in a DF

Question 11

df.head(n)

Answer 11

prints the first n rows of the DF

Question 12

df.tail(n)

Answer 12

prints the last n rows of the DF

Question 13

df.info()

Answer 13

returns the index, data type, and memory info