Scribd
Upload
17 views

Top Pandas - Functions

Uploaded by

muraliinfo24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views

Top Pandas - Functions

Uploaded by

muraliinfo24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 17

PANDAS

IMPORTANT
FUNCTIONS

follow for more @Lovee Kumar


TOP 15 IMPORTANT
PANDAS FUNCTIONS
pd.read_csv( )

pandas.read_csv() is used to read a CSV (Comma


Separated Values) file and convert it into a pandas
DataFrame.

CODE:

OUTPUT:
df.info()

df.info() is used to display a summary of a data frame,


including the data types and the number of non-null
values in each column.

CODE:

OUTPUT:
df.describe()

df.describe() method in Pandas is used to generate


descriptive statistics of the columns of a DataFrame.
useful for getting a quick overview of the distribution of the
data(mean, median, mode) and measures of dispersion
(standard deviation, range, interquartile range).

CODE:

OUTPUT:
df.assign()

df.assign() method in Pandas is used to add new columns


to a DataFrame.

CODE:

OUTPUT:
df.sample()

df.sample() function returns a random sample of rows


from a DataFrame.By default, it returns one random
row, but the number of rows can be specified as an
argument. For example, df.sample(5) returns 5 random
rows from the DataFrame. This function can be useful
for getting a quick understanding of the distribution of
values in a large dataset.

CODE:

OUTPUT:
df.head()

df.head() function returns the first n (default 5) rows of


a DataFrame.The n number of rows can be specified as
an argument, for example df.head(10) returns the first
10 rows of the DataFrame.
CODE:

OUTPUT:
df.tail()

The df.tail() function returns the last n (default 5) rows


of a DataFrame. The n number of rows can be specified
as an argument, for example df.tail(10) returns the last
10 rows of the DataFrame.

CODE:

OUTPUT:
df.drop( )

df.drop() method in pandas is used to remove rows or


columns from a data frame.

CODE:

OUTPUT: Customer_Age and Age_Group column is dropped from the data frame
df.dropna( )

df.dropna() method in Python is used to remove any rows


that contain missing values (i.e. NaN) from a DataFrame.
This can be useful for cleaning data before analysis or
modeling.

CODE:

OUTPUT:
Before After
df.query()

df.query() is used to filter rows of a DataFrame based


on a condition.

CODE:

OUTPUT:
df.sort_values()

df.sort_values() method in Pandas is used to sort the


rows of a DataFrame based on the values of columns.

CODE: CODE:

OUTPUT:

OUTPUT:
df.groupby().sum()

df.groupby() is used to group a data frame by one or


more columns. The result is a new data frame that has the
grouped columns as the index, and the other columns are
aggregated using a specified aggregation method.

CODE:

OUTPUT:
df.merge()

df.merge() is used to combine two or more DataFrames


into a single data frame. The function works by joining
the DataFrames on one or more common columns,
similar to a SQL JOIN operation

CODE:

OUTPUT:
df.rename()

df.rename() is used to rename one or more columns in


a data frame.

CODE:

OUTPUT:
df.to_csv()

df.to_csv() is used to save a data frame(export data) to


a CSV (Comma Separated Values) file.

CODE:

OUTPUT:

follow for more @Lovee Kumar

You might also like