DataFrame.to_csv()

DataFrame.to_csv(path_or_buf=None, sep=', ', na_rep='', float_format=None, columns=None, header=True, index=True, index_label=None, mode='w', encoding=None, compression=None, quoting=None, quotechar='"', line_terminator='\n', chunksize=None, tupleize_cols=False, date_format=None, doublequote=True, escapechar=None, decimal='.') [source] Write DataFrame to a comma-separated values (csv) file Parameters: path_or_buf : string or file handle, default None File path or object, if None is provid

DataFrame.to_clipboard()

DataFrame.to_clipboard(excel=None, sep=None, **kwargs) [source] Attempt to write text representation of object to the system clipboard This can be pasted into Excel, for example. Parameters: excel : boolean, defaults to True if True, use the provided separator, writing in a csv format for allowing easy pasting into excel. if False, write a string representation of the object to the clipboard sep : optional, defaults to tab other keywords are passed to to_csv Notes Requirements for your

DataFrame.take()

DataFrame.take(indices, axis=0, convert=True, is_copy=True, **kwargs) [source] Analogous to ndarray.take Parameters: indices : list / array of ints axis : int, default 0 convert : translate neg to pos indices (default) is_copy : mark the returned frame as a copy Returns: taken : type of caller

DataFrame.tail()

DataFrame.tail(n=5) [source] Returns last n rows

DataFrame.T

DataFrame.T Transpose index and columns

DataFrame.swaplevel()

DataFrame.swaplevel(i=-2, j=-1, axis=0) [source] Swap levels i and j in a MultiIndex on a particular axis Parameters: i, j : int, string (can be mixed) Level of index to be swapped. Can pass level name as string. Returns: swapped : type of caller (new object) Changed in version 0.18.1: The indexes i and j are now optional, and default to the two innermost levels of the index.

DataFrame.swapaxes()

DataFrame.swapaxes(axis1, axis2, copy=True) [source] Interchange axes and swap values axes appropriately Returns: y : same as input

DataFrame.sum()

DataFrame.sum(axis=None, skipna=None, level=None, numeric_only=None, **kwargs) [source] Return the sum of the values for the requested axis Parameters: axis : {index (0), columns (1)} skipna : boolean, default True Exclude NA/null values. If an entire row/column is NA, the result will be NA level : int or level name, default None If the axis is a MultiIndex (hierarchical), count along a particular level, collapsing into a Series numeric_only : boolean, default None Include only float,

DataFrame.subtract()

DataFrame.subtract(other, axis='columns', level=None, fill_value=None) [source] Subtraction of dataframe and other, element-wise (binary operator sub). Equivalent to dataframe - other, but with support to substitute a fill_value for missing data in one of the inputs. Parameters: other : Series, DataFrame, or constant axis : {0, 1, ?index?, ?columns?} For Series input, axis to match Series index on fill_value : None or float value, default None Fill missing (NaN) values with this value.

DataFrame.sub()

DataFrame.sub(other, axis='columns', level=None, fill_value=None) [source] Subtraction of dataframe and other, element-wise (binary operator sub). Equivalent to dataframe - other, but with support to substitute a fill_value for missing data in one of the inputs. Parameters: other : Series, DataFrame, or constant axis : {0, 1, ?index?, ?columns?} For Series input, axis to match Series index on fill_value : None or float value, default None Fill missing (NaN) values with this value. If bo