XII IP Codes

Creation of DataFrame from Dictionary of Series.

import pandas as pd

import numpy as np

ResultSheet={

'Arnab': pd.Series([90, 91, 97],index=['Maths','Science','Hindi']),

'Ramit': pd.Series([92, 81, 96],index=['Maths','Science','Hindi']),

'Samridhi': pd.Series([89, 91, 88],index=['Maths','Science','Hindi']),

'Riya': pd.Series([81, 71, 67],index=['Maths','Science','Hindi']),

'Mallika': pd.Series([94, 95, 99],index=['Maths','Science','Hindi'])

}

ResultDF = pd.DataFrame(ResultSheet)

#ResultDF.loc['IP']=[78,79,89,88,np.NaN]

#print(ResultDF.T)

#print(ResultDF.loc[['Maths','Hindi'],['Riya','Ramit']])

#print("***************************")

#print(ResultDF.columns)

#print("***************************")

#print(ResultDF.loc['Hindi'])

# How to modify the Data of Existing Column

#ResultDF['ramit']=[88,77,99,34]

#How to add NEW Column in a DataFrame

#ResultDF['jatinder']=[88,77,99,45] 

#print(ResultDF)

# How to update the marks of existing Student

#ResultDF['Arnab']=99

# How to Add the Row in a Data Frame

#ResultDF.loc['IP']=[78,79,89,88,98,97]

#print(ResultDF)

# How to update the Data of Existing Row

#ResultDF.loc['Science']=[78,79,89,88,98,97]

#ResultDF.loc['IP']=0

#How to update the data of all the Columns and Rows

#ResultDF[:]=90

#How to delete a Row

#ResultDF = ResultDF.drop('Maths',axis=0)

#How to Delete a COLUMN

#ResultDF = ResultDF.drop('Riya',axis=1)

# How to REname a Row index

#ResultDF=ResultDF.rename(

#  {'Maths':'Sub1',

#    'Science':'Sub2',

#     'Hindi':'Sub4'}, axis='index')

# How to RENAME A COLUMN NAME

#ResultDF=ResultDF.rename(

#    {'Arnab':'Student1'}, axis='columns')

#print(ResultDF['Ramit'])

#print(ResultDF.loc[:,'Ramit'])

#print(ResultDF.loc['Maths']>=90)

#print(ResultDF.loc[[False,True,False,True]])

print(ResultDF)

"""

#print(type(ResultDF))

#ResultDF['Riya']=90

ResultDF.loc['maths']=[90,98,97,99,98]

print(ResultDF)

#How to Export Data From DataFrame to CSV file

ResultDF.to_csv(path_or_buf='c://NCERT//student.csv',sep='#')

#How to Import Data From CSV file to DataFrame

marks = pd.read_csv('c://NCERT//student.csv',sep='#',header=0)

print(marks)"""