Skip to content

Instantly share code, notes, and snippets.

@analyticsindiamagazine
Created November 26, 2019 06:20
Show Gist options
  • Save analyticsindiamagazine/568cff398e0705f8b2ff5a0f53221f53 to your computer and use it in GitHub Desktop.
Save analyticsindiamagazine/568cff398e0705f8b2ff5a0f53221f53 to your computer and use it in GitHub Desktop.
#Loading Data
train = pd.read_excel("/GD/.../DataSets/Data_Train.xlsx")
#display the dataframe head(10) returns the first 10 rows
train.head(10)
#Shape of a table (number or rows, number of columns)
train.shape
#Display the names of all columns in a dataframe
train.columns
#Number of null values or empty cells present in each of the column
train.isnull().sum()
#Displays stastical information about each of the columns eg. count, frequency of occurance of a value etc
train.describe(include = 'all')
#Displays each of the column along with its type and the memory used by the data
train.info()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment