Class name Subject Book title Chapter number Content Created at
Class XII Informatics Practices Informatics Practices 3 22 25 22 22 Mishti 2 18 21 25 24 23 Mishti 3 17 18 20 25 20 Mishti 4 14 20 19 20 To calculate the final result, teachers are asked to submittheperc...
Class XII Informatics Practices Informatics Practices 3 False False 7 False False False False False False False 8 False False False False False False False 9 False False False False False False False 10 ...
Class XII Informatics Practices Informatics Practices 3 use df.isnull().sum().sum(). >>> print(df.isnull().sum().sum()) Program 3-12 Write a program to find the percentage of marks scored by Raman in hin...
Class XII Informatics Practices Informatics Practices 3 appropriate value. Dropping will remove the entire row (object) having the missing value(s). This strategy reduces the size of the dataset used in ...
Class XII Informatics Practices Informatics Practices 3 Scored by Raman in Maths 76.0 % Note that the number of rows in dfRaman is 3 after using dropna. Hence percentage is computed from marks obtained i...
Class XII Informatics Practices Informatics Practices 3 >>> print("Marks Scored by Raman in English \n\n",dfEng) Marks Scored by Raman in English 0 21.0 1 24.0 2 23.0 3 NaN Name: Eng, dtype: float64 >>> ...
Class XII Informatics Practices Informatics Practices 3 the python environment using the following command: pip install pymysql sqlalchemy is a library used to interact with the MySQL database by providi...
Class XII Informatics Practices Informatics Practices 3 LXIE | 2017 | Petrol | | S002 | Car4 | 614000.00 | VXI | 2018 | Petrol | +-------+--------+-----------+-----------+-----------------+----------+ 8 ...
Class XII Informatics Practices Informatics Practices 3 is used to write the specified DataFrame to the table the connection identifier (sql_conn) returned from the create_engine (). • The parameter if_e...
Class XII Informatics Practices Informatics Practices 3 for handling missing data. Either the row (or column) having missing value is removed completely from analysis or missing value is replaced by some...
Class XII Informatics Practices Informatics Practices 3 10000 650 TV LG 15000 800 AC SONY 14000 750 a) To create the data frame for the above table. b) To add the new rows in the data frame. c)To display...
Class XII Informatics Practices Informatics Practices 4 C h a p t e r Plotting Data using 4 Matplotlib “Human visual perception is the “most powerful of data interfaces between computers and Humans” — M....
Class XII Informatics Practices Informatics Practices 4 the following command: import matplotlib.pyplot as plt Here, plt is an alias or an alternative name for matplotlib.pyplot. We can use any other ali...
Class XII Informatics Practices Informatics Practices 4 can click on the save button on the output window and save the plot as an image. A figure can also be saved by using savefig() function. The name o...
Class XII Informatics Practices Informatics Practices 4 y-axis. Reprint 2026-27 PlottinData usinMatPlotlib 109 Program 4-2 Plotting a line chart of date versus temperature by adding Label on X and Y axis...
Class XII Informatics Practices Informatics Practices 5 each communicating device connects to a transmission medium, known as bus. Data sent from a node are passed on to the bus and hence are transmitted...
Class XII Informatics Practices Informatics Practices 4 colour of the plotted data. Table 4.4 shows the list of colours that are supported. We can either use character codes or the color names as values ...
Class XII Informatics Practices Informatics Practices 4 weight with respect to average height') #plot using marker'-*' and line colour as green plt.plot(df.weight,df.height,marker='*',markersize=10,color...
Class XII Informatics Practices Informatics Practices 4 area Area plot pie Pie plot scatter Scatter plot In the previous chapters, we have learned to store different types of data in a two dimensional fo...
Class XII Informatics Practices Informatics Practices 4 df.plot(kind='line', color=['red','blue','brown']) # Set title to "Mela Sales Report" plt.title('Mela Sales Report') # Label x axis as "Days" plt.x...
Class XII Informatics Practices Informatics Practices 4 on Thursday for Week 2 and on Tuesday for Week 3. But, the lines are unable to efficiently depict comparison between the weeks for which the sales ...
Class XII Informatics Practices Informatics Practices 4 The following example shows various customisations on the bar chart of Figure 4.8 Program 4-7 Let us write a Python script to display Bar plot for ...
Class XII Informatics Practices Informatics Practices 4 4.9. On the basis of the height and weight values provided in the DataFrame, the plot() calculated the bin values. Figure 4.9: A histogram as outpu...
Class XII Informatics Practices Informatics Practices 4 Series - India from 1901 to 2017” from the URL https://data.gov.in/resources/seasonal-andannual-minmax-temp-series-india-1901-2017. Our aim is to p...
Class XII Informatics Practices Informatics Practices 4 Scatter plots are used when you want to show the relationship between two variables. Scatter plots are sometimes called correlation plots because t...