[go: up one dir, main page]
Scribd
Upload
20 views8 pages

Index Table

Class 12 SQL and paython pandas index in series for cbse board

Uploaded by

csk500676
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 views8 pages

Index Table

Class 12 SQL and paython pandas index in series for cbse board

Uploaded by

csk500676
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
You are on page 1/ 8

INDEX

S.NO TITLE DATE PG SIGN


NO.
1 MYSQL 12-4-24

1 CREATION OF 12-4-24 1
TABLE
2 SCALAR 18-4-24
FUNCTION
1 TEXT FUNCTION 2-5-24 3

1.1 RIGHT() “ 3

1.2 LEFT() “ 3

1.3 MID() “ 3

1.4 SUBSTR() “ 4

1.5 LENGTH() “ 4
1.6 INSTR() “ 4

1.7 TRIM() “ 5
1.7.1 RTRIM() “ 5
1.7.2 LTRIM() “ 5
1.8 REPLACE() “ 6
1.9 REVERSE() “ 6
1.10 REPEAT() “ 6
1.11 CONCAT() 8-5-24 6

2 MATH FUNCTION 18-4-24


7
2.1 ABS() “
7
2.2 MOD() “
7
2.3 SQRT() 2-5-24 8
2.4 ROUND() “ 8
2.5 TRUNCATE() “ 9
2.6 POW() “ 9
3 DATE FUNCTION 14-5-24 10
3.1 CURDATE() “ 10
3.2 NOW() “ 10
3.3 SYSDATE() “ 10
3.4 DATE() “ 10
3.5 MONTH() “ 11
3.6 YEAR() “ 11
3.7 DAYNAME() “ 11
3.8 DAYOFMONTH() “ 11
3.9 MONTHNAME() “ 12
3.10 DOW() “ 12
3.11 DOY() “ 13

3 AGGREGATE 16-5-24 13
FUNCTION
1 COUNT() “ 13
2 SUM() “ 13
3 MAX() “ 13
4 MIN() “ 14
5 AVG() “ 14

4 ORDER BY 20-5-24 15

5 GROUP BY 24-5-24 16
6 HAVING CLAUSE 14-7-24 17
PYTHON PANDAS 18

2 SERIES 15-7-24

1 SERIES CREATION “

1 EMPTY SERIES “ 19
2 LIST 20
3 DOUBLE LIST “ 21
4 DICTIONARY 19-7-24 22
5 MATHEMATICAL “ 23
OPERATION
6 ND-ARRAY “ 24
7 SCALAR DATA “ 25
3 DATAFRAME 5-8-24 26

1 CREATION “

1 EMPTY “ 26
DATAFRAME
2 SINGLE LIST “ 27

3 NESTED LIST “ 28

4 DICTIONARY OF 21-8-24 29
LIST
5 DICTIONARY OF “ 29
SERIES
6 LIST OF 5-8-24 30
DICTIONARY
7 ND ARRAY 21-8-24 31
8 LIST OF SERIES “ 32

2 FUNCTIONS 28-8-24

1 MAX() “ 33
2 MIN() “ 33
3 SUM() “ 34
4 COUNT() 28-8-24 34
5 MODE() “ 34
6 MEDIAN() “ 35
7 MEAN “ 35

4 MATPLOTLIB 2-9-24

1 LINE CHART 9-9-24 36


2 BAR CHART 9-9-24 37

You might also like