Gyan Prakash Tripathi prakashthegyan
prakashthegyan
/ Reading Files
Created
February 4, 2020 11:38
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import pandas as pd | |
| marks10th=pd.read_csv('10thClassMarks.csv') | |
| marks12th=pd.read_csv('12thClassMarks.csv') | |
| IDandName=pd.read_csv('StudentIDandName.csv') |
prakashthegyan
/ Names of Toppers
Created
February 4, 2020 09:44
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mergedData.loc[mergedData['Exam Points']==100] |
prakashthegyan
/ Merged Data
Last active
February 6, 2020 05:54
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mergedData=allMarks.merge(IDandName, on='student id') | |
| mergedData.head() |
prakashthegyan
/ Maximum Marks Scored
Created
February 4, 2020 09:40
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| allMarks['Exam Points'].max() # Maximum Marks |
prakashthegyan
/ Mean of a column
Created
February 4, 2020 09:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| allMarks['Exam Points'].mean() #Average Marks |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| allMarks=marks10th.append(marks12th) | |
| marks10th.shape, marks12th.shape, allMarks.shape |
prakashthegyan
/ gist:36bbded6a42d8725f68eb1df3f128323
Last active
February 4, 2020 08:58
View the head of dataframe
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| marks10th.head() | |
| marks12th.head() | |
| IDandName.head() |
prakashthegyan
/ capstoneNotebook-Copy1.ipynb
Created
April 24, 2019 05:48
Created on Cognitive Class Labs
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
NewerOlder