Page 13 - Informatics_Practices_Fliipbook_Class12
P. 13

CONTENTS





                                           CONTENTS
             Unit I: Data Handling using Pandas-I

              1.  Data Handling using Pandas                                                                   1

                 1.1   Series                                1.2  Indexing and Slicing
                 1.3  Typecasting                            1.4  Using Dictionary to Create Series Object

                 1.5  Operations on Series Objects

              2.  Data Handling using Pandas DataFrame                                                        30
                 2.1  Pandas DataFrame                       2.2  Creation of Pandas Dataframe
                 2.3  Reading from csv File                  2.4  Dimensions of a DataFrame

                 2.5  Summary Information about a DataFrame   2.6  Retrieving Subset of Data - Indexing and Slicing

                 2.7  Descriptive Statistics                 2.8  Data Manipulation
                 2.9  Writing to csv file                    2.10  Grouping and Aggregation

              3.  Data Visualization                                                                          90
                 3.1  Displaying the line graph              3.2  Bar Graph

                 3.3  Histogram


             Unit II: Database Query using SQL
              4.  Database Query using SQL                                                                   124

                 4.1  Database Management System (DBMS)

                 4.2  Relational Data Model
                 4.3  Structured Query Language (SQL)
                 4.4  SQL Statements and Functions

              5.  SQL: Working with Two Tables                                                               187

                 5.1  Referential Integrity


             Unit III: Introduction to Computer Networks
              6.  Computer Networks                                                                          221

                 6.1  Components of a Computer Network

                 6.2  Evolution of Networking
                 6.3  Network Topologies

                 6.4  Network Types
                 6.5  Network Devices

                                                             (xi)
   8   9   10   11   12   13   14   15   16   17   18