DataFrames और उनके methods

स्प्रेडशीट उपयोगकर्ताओं के लिए Python

Chris Cardillo

Data Scientist

जहाँ हम रुके थे

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

print(fruit)

simple fruit whole dataset.png

pandas DataFrame की बनावट

simple fruit whole dataset.png

pandas DataFrame की बनावट

simple fruit df cols.png

pandas DataFrame की बनावट

simple fruit df numerical column.png

pandas DataFrame की बनावट

simple fruit df object-character column.png

pandas DataFrame की बनावट

simple fruit df rows 1.png

pandas DataFrame की बनावट

simple fruit df rows 2.png

pandas DataFrame की बनावट

simple fruit df index.png

DataFrame methods

.head()
.info()
.describe()
.sort_values()

.head() method

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

print(fruit.head())

simple fruit df head.png

.head() method

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

print(fruit.head(2))

simple fruit df head with arg.png

.info() method

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

print(fruit.info())

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 8 entries, 0 to 7
Data columns (total 3 columns):
 #   Column     Non-Null Count  Dtype  
 --  ------     --------------  -----  
 0   name       8 non-null      object 
 1   color      8 non-null      object 
 2   price_usd  8 non-null      float64
dtypes: float64(1), object(2)
memory usage: 272.0+ bytes

.describe() method

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

print(fruit.describe())

simple fruit df describe method.png

.sort_values() method

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

fruit = fruit.sort_values('name')
fruit = fruit.reset_index(drop=True)

print(fruit)

simple fruit df sorted by name asc.png

.sort_values() method

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

fruit = fruit.sort_values('price_usd', ascending=False)
fruit = fruit.reset_index(drop=True)

print(fruit.head(3))

simple fruit df sorted by price desc head 3.png

अब आपकी बारी!

स्प्रेडशीट उपयोगकर्ताओं के लिए Python