pandas

Question 1

pd.ExcelFile( )

Answer 1

parse specified sheet(s) into DataFrame, equivalent to read_excel

data type
pandas.io.excel._base.ExcelFile

Question 2

xls.sheet_names

Answer 2

return a list of sheet names in the xls

Question 3

xls.parse( )

Answer 3

parse the sheet in xls into DataFrame

Question 4

df.duplicated( )

Answer 4

return boolean Series denoting duplicates row

• subset = [column label or sequence of labels]
  only consider/use certain columns for identifying duplicates, by default use all of the columns.
• keep = {‘first’, ‘last’, False}

Question 5

pd.pivot_table( )

Answer 5

create a spreadsheet-style pivot table as a DataFrame

• data: data frame providing the info
• values
• index
• columns
• ## aggfunc

Question 6

pivot table

Answer 6

a table of statistics that summarizes data of a more extensive table (such as from a database, spreadsheet, or business intelligence program)

Question 7

df.isnull( )

Answer 7

To detect missing values, return bool values for each element in DataFrame

Parameters:
- None

Question 8

se.map( )

Answer 8

Map values of Series according to input correspondence.

Question 9

pd.concat( )

Answer 9

Concatenate pandas objects along a particular axis

Question 10

df.se.str.cat( )

Answer 10

To join two columns in a data frame