Scribd
Upload
4 views14 pages

Project Programs Class12 SimplerMatplotlib

Uploaded by

nikhilog7
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views14 pages

Project Programs Class12 SimplerMatplotlib

Uploaded by

nikhilog7
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

20 Pandas Programs (Intermediate Level)

1. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

2. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

3. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

4. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

5. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

6. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

7. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

8. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

9. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

10. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

11. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

12. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85
Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

13. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

14. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

15. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85
Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

16. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

17. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

18. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85
Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

19. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

20. Pandas Program Example


import pandas as pd
df = [Link]({'Name':['A','B','C'],'Marks':[80,90,85]})
print(df)
print([Link]())
Output:
Name Marks
0 A 80
1 B 90
2 C 85

Marks
count 3.0
mean 85.0
std 5.0
min 80.0
max 90.0

20 SQL Queries (Intermediate Level)

1. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85
2. SQL Query Example
SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

3. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

4. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

5. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

6. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

7. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

8. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

9. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

10. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

11. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

12. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85
13. SQL Query Example
SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

14. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

15. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

16. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

17. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

18. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

19. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

20. SQL Query Example


SELECT Name, Marks FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
Output:
Name | Marks
-----|------
Amit | 90
Riya | 85

15 Simpler Matplotlib Programs (with Code and


Output)

1. Simple Line Plot


import [Link] as plt
x = [1,2,3,4,5]
y = [2,4,6,8,10]
[Link](x, y)
[Link]('Simple Line Plot')
[Link]('X')
[Link]('Y')
[Link]()
Output: A straight line increasing proportionally.

2. Multiple Lines
import [Link] as plt
x = [1,2,3,4,5]
[Link](x, [a*2 for a in x], label='2x')
[Link](x, [a*3 for a in x], label='3x')
[Link]()
[Link]()
Output: Two lines with different slopes.

3. Bar Graph
import [Link] as plt
x = ['A','B','C']
y = [85,90,80]
[Link](x, y, color='orange')
[Link]('Student Marks')
[Link]()
Output: Vertical bars for A, B, C.
4. Horizontal Bar Graph
import [Link] as plt
x = ['Maths','Science','English']
y = [88,92,85]
[Link](x, y, color='green')
[Link]('Subject Scores')
[Link]()
Output: Horizontal bars representing scores.

5. Pie Chart
import [Link] as plt
sizes = [30, 40, 20, 10]
labels = ['Apples','Bananas','Cherries','Dates']
[Link](sizes, labels=labels, autopct='%1.1f%%')
[Link]('Fruit Distribution')
[Link]()
Output: Pie chart showing four fruits with percentages.

6. Scatter Plot
import [Link] as plt
x = [1,2,3,4,5]
y = [5,4,3,2,1]
[Link](x, y, color='red')
[Link]('Scatter Example')
[Link]()
Output: Red points forming a downward line.

7. Histogram
import [Link] as plt
import numpy as np
data = [10,20,20,30,30,30,40,40,50]
[Link](data, bins=5, color='purple', edgecolor='black')
[Link]('Histogram Example')
[Link]()
Output: Bars showing frequency distribution of data.

8. Box Plot
import [Link] as plt
import numpy as np
data = [10,20,30,40,50,60,70,80,90]
[Link](data)
[Link]('Box Plot Example')
[Link]()
Output: Box showing median and quartile range.

9. Stem Plot
import [Link] as plt
x = [1,2,3,4,5]
y = [2,4,1,3,5]
[Link](x, y)
[Link]('Stem Plot Example')
[Link]()
Output: Stems from x-axis to y values.

10. Stack Plot


import [Link] as plt
y1 = [2,4,6]
y2 = [1,3,5]
[Link]([1,2,3], y1, y2, labels=['A','B'])
[Link]()
[Link]('Stack Plot Example')
[Link]()
Output: Stacked areas showing cumulative totals.

11. Subplots
import [Link] as plt
fig, ax = [Link](1,2)
ax[0].plot([1,2,3],[4,5,6])
ax[1].bar(['A','B','C'],[3,2,4])
[Link]()
Output: Line plot and bar plot side by side.

12. Line Style and Color


import [Link] as plt
x = [1,2,3,4]
y = [10,20,15,25]
[Link](x, y, 'r--')
[Link]('Red Dashed Line')
[Link]()
Output: Red dashed line plot.

13. Adding Grid


import [Link] as plt
x = [1,2,3,4,5]
y = [2,3,5,7,11]
[Link](x, y)
[Link](True)
[Link]('Line Plot with Grid')
[Link]()
Output: Line graph with grid lines visible.

14. Labeling Points


import [Link] as plt
x = [1,2,3]
y = [10,20,30]
[Link](x,y,'bo')
for i,j in zip(x,y):
[Link](i, j, str(j))
[Link]('Labelled Points')
[Link]()
Output: Blue points with numeric labels above each.

15. Saving a Plot


import [Link] as plt
x = [1,2,3]
y = [2,4,6]
[Link](x,y)
[Link]('Saving Example')
[Link]('[Link]')
[Link]()
Output: Line plot displayed and saved as '[Link]'.

You might also like