INFORMATICS PRACTICES - LESSON NOTES

 REVIEW OF NUMPY 
     Working with Numpy 

 PYTHON PANDAS 

• Introduction to Pandas and Series 
• Data Frames
• Data Frame Creation
• Data Frames - Creating list, Dictionary and text files
• Data Frames - Creation through csv files and iteration
• Advance operation on Data Frame 
• Data Frame operations group by renaming index
• Data Frames - Descriptive Statistics
• Importing / Exporting Data between MySql and Pandas

  DATA VISUALIZATION 

• Data Visualization using Pyplot Part 1
• Data Visualization using Pyplot Part 2
• Data Visualization using Pyplot Part 3

DATABASE QUERY USING SQL

Introduction to MYSQL

SQL functions

SQL Group By clause 

SQL Connectivity with python 

INTRODUCTION TO COMPUTER NETWORKS

 SOCIETAL IMPACT