Top 10 Pandas Functions

1 – To Read CSV and Excel files.

These Functions will be used in almost every Project, They are used to read a CSV or an excel file to pandas DataFrame format.

2 – Columns Function.

When we have a big dataset with many columns it will be difficult to see all columns, hence we can use df.columns to print all columns

3 – Head and Tail Function.

  • df.head() returns first n rows, if no input is given it returns 5 rows.
  • df.tail() returns the last n rows, if no input is given it returns 5 rows.
  • df.sample() returns the random values if input is given.

4 – length and Shape Functions.

  • len(df) function provides the length of the DataFrame
  • df.shape function returns no of rows and columns in a data frame.

5 – Describe Function

To understand the basic statistics of variables we can use df.describe().

6 – Nunique Function

To get the total unique values of variables, we can use df.nunique().

7 – iloc() Function

This function takes as a parameter the rows and columns indices and gives you the subset of the DataFrame accordingly.

8 – loc() Function

This function does almost the similar operation as iloc() function. But here we can specify exactly which row index we want and also the name of the columns we want in our subset.

9 – dtypes Function

We use this function to find the data type of a column.

10 – Replacing Null values

This function .fillna() replaces the null values with some other value of your choice.

Popular Posts

Spread the knowledge

Leave a Reply

Your email address will not be published. Required fields are marked *