[go: up one dir, main page]
Scribd
Upload
4 views287 pages

NumPy and Pandas

Uploaded by

Redmi 11t 5g
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
4 views287 pages

NumPy and Pandas

Uploaded by

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

Create a 3x5 array having all elements 3.

14

print(np.full((3,5),3.14))
Create a diagonal matrix having elements [3,2,4,5]

print(np.diag([3,2,4,5]))
Create a 3-dimensional array with the elements [1,2,3,4,5,6,7,8]

print(np.array([1,2,3,4,5,6,7,8]).reshape(2,2,2))
What is the output of the command: np.arange(1,10,3.0)
What is the output of the command: np.linspace(1,6,5)
Write a command to fill all the missing
print(df.fillna(999))
values with 999
Write a command to fill all the missing
values using forward filling across columns print(df.fillna(method='ffill',axis=1))
Write a command to drop the columns
containing all missing values
print(df.dropna(axis=1,how='all'))
Write a command to print all the rows
containing at least 2 non-missing values
print(df.dropna(axis=0,thresh=2))
Write a command to drop all the rows
containing missing values.
print(df.dropna())
print(df1+df2)
print(df1.add(df2,fill_value=0))
print(df1-df1.iloc[1])
print(df1-df1.loc[1])
print(df.loc[:,'A'])
print(df.loc[['a','b', 'd','e'],['A','C']])
print(df.loc['a']>0)
print(df.iloc[1:5, 2:4])
print(df.loc['b':'e', 'B':'D'])
print(df[df['Name']=='Ram'])
print(df[df['Age']>30]['Name'])
print(df[df['Score']>df['Score'].mean()]['Name'])
import numpy as np
import pandas as pd data=[['A',24,78],['B',25,69],['C',22,89],['D',23,82]]
df=pd.DataFrame(data,index=[1,2,3,4],columns=['Name','Age','Score'])
print(np.sum(df['Score']))
print(np.prod(df['Score']))
print(np.min(df['Score']))
print(np.argmin(df['Score']))
print(np.max(df['Score']))
print(np.argmax(df['Score']))
print(np.mean(df['Score']))
print(np.median(df['Score']))
print(np.var(df['Score']))
print(np.std(df['Score']))
print(np.percentile(df['Score'],50))

You might also like