Class name Subject Book title Chapter number Content Created at
Class XII Informatics Practices Informatics Practices 1 in SELECT and FROM clauses to indicate its scope. b) Explicit use of JOIN clause mysql> SELECT * FROM UNIFORM U JOIN COST C ON U.Ucode=C.Ucode; The...
Class XII Informatics Practices Informatics Practices 1 JOIN with ON clause or NATURAL JOIN in FROM clause. If three tables are to be joined on equality condition, then two JOIN or NATURAL JOIN are requi...
Class XII Informatics Practices Informatics Practices 1 name of the month in which you were born. iv)To display your name in capital letters. 2. Write the output produced by the following SQL commands: a...
Class XII Informatics Practices Informatics Practices 1 the chapter, write the SQL queries for the following: a) Add a new column Discount in the INVENTORY table. b) Set appropriate discount values for a...
Class XII Informatics Practices Informatics Practices 1 of students in each stream having more than 1 student. h) Display the names of students enrolled in different streams, where students are arranged ...
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 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 Serie...
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 use p...
Class XII Informatics Practices Informatics Practices 2 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 the elem...
Class XII Informatics Practices Informatics Practices 2 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 used w...
Class XII Informatics Practices Informatics Practices 2 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 We can ...
Class XII Informatics Practices Informatics Practices 2 values and we b NaN want to replace it by a c -0.06 specific value to have d NaN a concrete output in place of NaN. Reprint 2026-27 40 nformatIcPra...
Class XII Informatics Practices Informatics Practices 2 of DataFrame from NumPy ndarrays Consider the following three NumPy ndarrays. Let us create a simple DataFrame without any column labels, using a s...
Class XII Informatics Practices Informatics Practices 2 >>> dictForest = {'State': ['Assam', 'Delhi', 'Kerala'], 'GArea': [78438, 1483, 38852] , 'VDF' : [2797, 6.72,1663]} >>> dFrameForest= pd.DataFrame(...
Class XII Informatics Practices Informatics Practices 2 each series becomes a row in the DataFrame. Now look at the following example: >>> dFrame8 = pd.DataFrame([seriesA, seriesC]) >>> dFrame8 a b c d e...
Class XII Informatics Practices Informatics Practices 2 'e']) } >>> dFrameUnion = pd.DataFrame(dictForUnion) >>> dFrameUnion Series1 Series2 Series3 a 1.0 -10.0 -10.0 b 2.0 NaN NaN c 3.0 -50.0 -50.0 d 4....
Class XII Informatics Practices Informatics Practices 2 ] method. Consider the DataFrame ResultDF that has three rows for thethree subjects – Maths, Science and Hindi. Suppose, we need to add the marks f...
Class XII Informatics Practices Informatics Practices 2 mismatched columns. program to count Similarly, if we try to add a column with lesser values the number of rows and columns in a than the number of...
Class XII Informatics Practices Informatics Practices 2 95 95 If the DataFrame has more than one row with the same label, the DataFrame.drop() method will delete all the matching rows from it. For exampl...
Class XII Informatics Practices Informatics Practices 2 71 95 English 97 96 88 67 99 Sub4 97 89 78 60 45 (E) Renaming Column Labels of a DataFrame To alter the column names of ResultDF we can again use t...
Class XII Informatics Practices Informatics Practices 2 ResultDF.loc[:,'Arnab'] Reprint 2026-27 50 InformatIPractIces n otes Maths 90 Science 91 Hindi 97 Name: Arnab, dtype: int64 Also, we can obtain the...
Class XII Informatics Practices Informatics Practices 2 DataFrames slicing is inclusivActivity 2.8 of the end values. We may use a slice of labels with a column name to access values of those rows in tha...
Class XII Informatics Practices Informatics Practices 2 present in the first DataFrame are added as new columns. For example, consider the two DataFrames— dFrame1 and dFrame2described below. Let us use t...
Class XII Informatics Practices Informatics Practices 2 duplicate row with label R2 when appending the two DataFrames, as shown above. The parameter ignore_index of append()method may be set to True, whe...