DATAFRAMES - nireeshach/python_training GitHub Wiki

to insert new column into csv using dataframes at particular index data.insert(loc=h + 1, column=similarity_col, value=emp_list)

https://stackoverflow.com/questions/18674064/how-do-i-insert-a-column-at-a-specific-column-index-in-pandas

to get column number or index number of a particular column h = data.columns.get_loc(z)

https://stackoverflow.com/questions/13021654/get-column-index-from-column-name-in-python-pandas

http://www.datasciencemadesimple.com/get-unique-values-rows-dataframe-python-pandas/

to get columns start with or contains a string

spike_cols = [col for col in df.columns if 'spike' in col]

https://stackoverflow.com/questions/21285380/pandas-find-column-whose-name-contains-a-specific-string

to convert dataframe records to dictionary

predicted_df.to_dict("records")

to drop particular list of columns col = [col1,col3..] df.drop(col, axis=1, inplace=Ture)