BASIC PANDAS FOR DATA ANALYSIS AND MACHINE LEARNING

                    BASIC PANDAS FOR DATA ANALYSIS AND MACHINE LEARNING

READING AND WRITING THE DATA

df=pd.read_csv("/kaggle/input/heart.csv")

df.to_csv("heart.csv")

df.to_excel("heart.xls")

xlsx = pd.ExcelFile("/kaggle/working/heart.xls")

 

Any data frame can be saved as a file. And any file can be read back to the data frame and vice versa.

SELECTING DATA FROM DATA FRAME

df.loc[1:10,["sex","chol","target"]]

df[(df.target==1) | (df.sex==1)]

df[(df.target==1) & (df.sex==1)]

COUNTING 

DROPING SOME COLUMNS AND ROWS OF THE TABLE (ABOVE)

When axis =0 it removes rows instead of columns and names are indexes