Class name Subject Book title Chapter number Content Created at
Class XII Informatics Practices Informatics Practices 1 Mahira | 6A | | 2 | Mahira | 6A | 2 | Mahira | 6A | | 3 | Mohit | 7B | 2 | Mahira | 6A | | 4 | Sanjay | 7A | 2 | Mahira | 6A | | 1 | Aastha | 7A | ...
Class XII Informatics Practices Informatics Practices 1 FROM clause, as shown in Example 1.7. On execution of such a query, the DBMS (MySql) will first apply cartesian product on specified tables to have...
Class XII Informatics Practices Informatics Practices 1 tables UNIFORM (UCode, UName, UColor) and COST (UCode, Size, Price) in the SchoolUniform database. UCode is Primary Key in table UNIFORM. UCode and...
Class XII Informatics Practices Informatics Practices 1 ambiguity. Hence, we have used qualifier with attribute UCode in SELECT and FROM clauses to indicate its scope. b) Explicit use of JOIN clause mysq...
Class XII Informatics Practices Informatics Practices 1 condition on the common attribute, then one may use JOIN with ON clause or NATURAL JOIN in FROM clause. If three tables are to be joined on equalit...
Class XII Informatics Practices Informatics Practices 1 particular position of the given string. iii) To display the name of the month in which you were born. iv)To display your name in capital letters. ...
Class XII Informatics Practices Informatics Practices 1 FROM Product GROUP BY PName; 4. Using the CARSHOWROOM database given in the chapter, write the SQL queries for the following: a) Add a new column D...
Class XII Informatics Practices Informatics Practices 1 admission number in ascending order (for duplicating names). g) List the number of students in each stream having more than 1 student. h) Display t...
Class XII Informatics Practices Informatics Practices 2 C h a p t e r Data Handling Using Pandas - I “If you don't think carefully, you might believe that programming is just typing statements in a progr...
Class XII Informatics Practices Informatics Practices 2 scatterplots, etc. It is also built on Numpy, and is designed to work well with Numpy and Pandas. You may think what the need for Pandas is when Nu...
Class XII Informatics Practices Informatics Practices 2 data label associated with a particular value is called its index. We can also assign values of other data types as index. We can imagine a Pandas ...
Class XII Informatics Practices Informatics Practices 2 >>> print(series2) #Display the series Think and Reflect Output: Feb 2 While importing Pandas, is it Mar 3 mandatory to always Apr 4 dtype: int64 u...
Class XII Informatics Practices Informatics Practices 2 #Display the series India NewDelhi UK London Japan Tokyo dtype: object 2.2.2 Accessing Elements of a Series There are two common ways for accessing...
Class XII Informatics Practices Informatics Practices 2 Paris dtype: object (B) Slicing Sometimes, we may need to extract a part of a series. This can be done through slicing. This is similar to slicing ...
Class XII Informatics Practices Informatics Practices 2 slicing is done using labels. >>> seriesAlph['c':'e'] = 500 >>> seriesAlph a 10 b 50 c 500 d 500 e 500 f 15 dtype: int32 2.2.3 Attributes of Series...
Class XII Informatics Practices Informatics Practices 2 n members of the seri>>> seriesTenTwenty.head(2) the value for n is not passed, then by default 1    11 n takes 5 and the first five members are di...
Class XII Informatics Practices Informatics Practices 2 the output of addition is NaN if one of the elements or both elements have no value. >>> seriesA + seriesB a -9.0 b NaN c -47.0 d NaN e 105.0 y NaN...
Class XI Health and Physical Education Health and Physical Education 5 batsman is given out (as long as at least one bail or stump is dislodged by the ball). Reprint 2026-27 Team Games 147 It does not matter whether th...
Class XII Informatics Practices Informatics Practices 2 mathematical operators or explicitly calling of the appropriate method. (B) Subtraction of two Series Again, it can be done in two different ways, ...
Class XII Informatics Practices Informatics Practices 2 preferred >>> seriesA/seriesB # using division operator when series may have a -0.10 missing values and we b NaN want to replace it by a c -0.06 sp...
Class XII Informatics Practices Informatics Practices 2 instead of Index: [] 4 in the above code? What is the reason? (B) Creation of DataFrame from NumPy ndarrays Consider the following three NumPy ndar...
Class XII Informatics Practices Informatics Practices 2 ‘State’, ‘GArea’ (geographical area) and ‘VDF’ (very dense forest) and the corresponding values as list. >>> dictForest = {'State': ['Assam', 'Delh...
Class XII Informatics Practices Informatics Practices 2 the labels in the series object become the column names in the DataFrame object and each series becomes a row in the DataFrame. Now look at the fol...
Class XII Informatics Practices Informatics Practices 2 = ['z', 'y', 'a', 'c', 'e']), 'Series3' : pd.Series([10,20,-10,-50,100], index = ['z', 'y', 'a', 'c', 'e']) } >>> dFrameUnion = pd.DataFrame(dictFo...
Class XII Informatics Practices Informatics Practices 2 to a DataFrame We can add a new row to a DataFrame using the DataFrame.loc[ ] method. Consider the DataFrame ResultDF that has three rows for theth...