@. *[Link] - D:/python/[Link] (3.14.2)* File Edit Format Run Options Window Help import pandas as pd data = { "Name": ["Aman", "Riya", "Karan", "Neha"], "Maths": (78, 85, 67, 90], "science": [82, 88, 70, 92], "English": [75, 80, 65, 89])} af = [Link] (data) df["Total"] = df["Maths"] + df["Science"] + df["English"] df ["Percentage"] = df["Total"] / 3 print (df) >>> RESTART :/python/aayush. py Name Maths Science English Total Percentage a| aman 7a 82 7S 235 78.333333 1 Riya 85 88 80 253-84. 333333 2 Karan e 70 65 202. 67.333333 3 Neha 20 92 89 271 90.333333#. *aayush py - D:/python/aayush py (3.14.2)* File Edit Format Run Options Window Help import pandas as pd data = { "Name": ["Aman", "Riya", "Karan", "Neha", "Rohit", "Marks": [92, 76, 64, 48, 35])} df = [Link] (data) def grade (m) = Lim >= 90: return "At elif m >= 75: return "A" elif m>= 6 return elif m>=4 return "Cc" else: return "E" df["Grade"] = d£["Marks"] .apply (grade) print (df) >>> SSeSSSSSSSSSSsSassssssss= RESTART: D:/python/[Link] ======== Name Marks Grade 0 aman 92 At 1 Riya 76 2 Karan 64 3 Neha = 48 4 Rohit 35 mom m#. *[Link] - D:/python/[Link] (3.14.2) File Edit Format Run Options import pandas as pd low Help data = { "Maths": [78, 85, 67, 90, 72], "Science": [82, 88, 70, 92, 75], "English": [75, 80, 65, 89, 70] } df = [Link] (data) print ("Subject-wise Average: ") print ([Link]()) print("\nOverall Class Average:") print ([Link]() -mean()) Subject-wise Average: Maths 76.4 Science 81.4 mnglish 75.8 dtype: floatéé Overall Class Average: 78 .53333333333335 a RESTART: D:/python/[Link] ==-=-=== *[Link] - D:/python/[Link] (3.14.2)* File Edit Format Run Options Window Help import pandas as pd data = { "Maths": [78, 85, 67, 90], "Science": [82, 88, 70, 92], "English": [75, 80, 65, 89]} df = pd. DataFrame (data) print ("Highest marks in each subject:") print ([Link]()) >>> sesssssssssssssssss====== RESTART: D:/python/[Link] ====== Highest marks in each subject: Maths 90 Science 92 English 89 dtype: int64 I& ‘aayushpy - Dupython/aayushpy 3.142)" File Edit Format Run Options Window Help, import pandas == pd 671, 90, 55) science = [62, 40, 70, $2, 60] english = [75, 38, 65, ®9, 58] Gf = [Link]() dz[vname"] = names dE{"Maths") = maths df["science"] = science d£["English"] = english total = 11 percentage = [] result = [1 for 4 in range (len (de): Riya", "Karan", "Neha", "Rohit") t = df["maths"] [i] + df["science"] [i] + df["englisn"] [i] ‘[Link](t) 73 pe percentage .append(p) Af GE["Maths"] [i] >= 40 and df["Science"] [i] >= 40 and d£["English"] [i] >= 40: [Link] ("Pass") else: [Link] ("Fail") d£["Total") = total dz["Percentage"] = percentage dE["Result") = result print ("Student Result Sheet") print (af) >>> sosssssssssssssssssscasss RESTART Student Result Sheet : D:/python/[Link] Name Maths Science English Total Percentage Result 0 aman 18 82 1) Riya 45 40 2 Karan a7 70 3) Neha 90 92 4 Rohit 55 60 15 38 65 89 58 235 123 202 21 173 78333333 41,000000 67. 333333 90. 333333 57.666667 Pass Fail Pass Pass Pass@. *[Link] - D/python/[Link] (3.14.2)* File Edit Format Run Options Window Help import pandas as pd names = ["Aman", "Riya", "Karan", "Neha", "Rohit"] total days = [200, 200, 200, 200, 200] present_days = [180, 150, 1€5, 190, 140] df = pd. DataFrame () df["Name"] = names df ["Total Days") = total_days df["eresent Days"] = present_days attendance = [] status = [] for i in range (len (d£)): att = (df["Present Days"I[il / df["Total Days"1[il) * 100 attendance. append (att) if att >= 75: status append ("Bligible") else: status append ("Not Fligible") df ["Attendance $"] = attendance af["Exam Status"] = status print ("Attendance Report") print (df) >>| ssscsssssss= RESTART: D:/python/[Link] === ‘Attendance Report Name ‘Total Days Present Days Attendance Exam Status Q Aman 200 180 90.0 Eligible 1 Riya 200 150 15.0 Eligible 2 Karan 200 165 82.5 Eligible 3. Neha 200 190 95.0 Eligible 4 Rohit 200 10 70.0 Not Eligible#. *[Link] - DA\python\[Link] (3.14.2)* File Edit Format Run Options Window Help. import pandas as pa emp - ["Rahul", "Anita", "Suresh", "Neha"] basic = [25000, 32000, 28000, 40000) af = [Link]() df ("Employee"] = emp df["Basic Salary"] = basic hra = [] da = [] gross = [] for i in range(len(daf)): h = df£["Basic Salary"J][i] * 0.20 d = df["Basic Salary"][i] * 0.10 g = af["Basic Salary"I[i] +#h+d hra. append (h) [Link] (da) [Link] (g) d@f["HRA"] = hra a@f["DA"] = da df["Gross Salary"] = gross print ("Salary Details") print (df) >> SSSSSSSSSsesssssssssssss= RESTART: D:\python\[Link] ========= Salary Details Employes Basic Salary HRA DA Gross Salary 0 Rabul 25000 5000.0 2500.0 32500.0 1 anita 32000 6400.0 3200.0 41600.0 2 suresh 28000 5600.0 2800.0 36400.0 3 Neha 40000 8000.0 4000.0 52000.04. taayush py - D:\python\[Link] (2.14.2)* File Edit Format Run Options Window Help import pandas as pd students = { "Roll No": [1, 2, 3, 4], "Name": ["Aman", "Riya", "Karan", "Neha"] } marks = { "Roll No": [1, 2, 3, 4], "Marks": [78, 85, 67, 90] } d£1 = [Link] (students) df2 = [Link] (marks) result = [Link](d£1, d£2, on="Roll No") print ("Merged DataFrame:") print (result) RESTART: D:\python\[Link] = Merged DataFrame: Roll No Name Marks 0 1 man 78 1 2 Riya 85 2 3 Karan 67 3 4 Neha (90# *aayushpy - DApython\aayush py (.14.2)* File Edit Format Run Options _ Window Help import pandas a5 pd data = { "Roll No": [1, 2, 3, 4, 5, 6 7], "Name": ["Aman", "Riya", "Karen", "Neha", "Rohit", "Pooja", “Ankit"], "Marks": [78, 85, 67, 90, 72, 88, 60] 1 df = [Link] (data) print ("First 5 Records:") print ([Link]()) print("\nFirst 3 Records:") print (df-head(3)) >>> RESTART: D:\python\[Link] First 5 Records: Roll No Name Marks 0 1 aman 78 1 2 Riya 85 2 3 karan 67 3 4 Neha 30 4 5 Rohit 72 First 3 Records: Roll No Name Marks 0 1 aman 78 1 2 Riya 85 2 3 karan 67 |#. *[Link] - D:\python\[Link] (3.14.2) File Edit Format Run Options Window Help import pandas 25 pd data = { "Name": ["aman", "Riya", "Karan", "Neha", "Rohit", "Pooja"], "Marks": [78, 85, 67, 90, 72, 88] } df = [Link] (data) print ("Top 3 Scorers:") print (df.sort_values (by="Marks", ascending=False) -head(3)) >>> sss== RESTART: D:\python\[Link] === Top 3 Scorers: Name Marks 3) Neha 90 5 Pooja 88 1 Riya 85 \