###### 1 Question Bank By KVS RO Jabalpur

Question Bank By KVS RO Jabalpur

Data Handling using Pandas -I

• Introduction to Python libraries- Pandas, Matplotlib.
• Data structures in Pandas – Series and Data Frames.
• Series: Creation of Series from – ndarray, dictionary, scalar value
• mathematical operations; Head and Tail functions; Selection, Indexing and Slicing
• Data Frames: creation – from dictionary of Series, list of dictionaries
• Text/CSV files display, iteration
• Operations on rows and columns
• Indexing using Labels, Boolean Indexing; Joining, Merging and Concatenation.
• Importing/Exporting Data between CSV files and Data Frames.

Data handling using Pandas – II

• Descriptive Statistics: max, min, count, sum, mean,
• median, mode, quartile, Standard deviation, variance
• DataFrame operations: Aggregation, group by, Sorting
• Deleting and Renaming Index, Pivoting.
• Handling missing values – dropping and filling.
• Importing/Exporting Data between MySQL database and Pandas.
• Data Visualization
• Purpose of plotting
• drawing and saving following types of plots using Matplotlib – line plot
• bar graph, histogram, pie chart, frequency polygon, box plot and scatter plot.
• Customizing plots: color, style (dashed, dotted), width
• adding label, title, and legend in plots.

Unit 2: Database Query using SQL

• Math functions: POWER (), ROUND (), MOD ().
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER ()
• MID ()/SUBSTRING ()/SUBSTR (), LENGTH ()
• LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().
• Date Functions: NOW (), DATE (), MONTH (), MONTHNAME ()
• YEAR (), DAY (), DAYNAME ().
• Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).
• Querying and manipulating data using Group by, Having, Order by.
• Operations on Relations – Union, Intersection, Minus, Cartesian Product, JOIN

Unit 3: Introduction to Computer Networks

• Introduction to networks
• Types of network: LAN, MAN, WAN
• Network Devices: modem, hub, switch, repeater, router, gateway
• Network Topologies: Star, Bus, Tree, Mesh.
• Introduction to Internet, URL, WWW and its applications- Web, email, Chat, VoIP.
• Website: Introduction, difference between a website and webpage
• static vs dynamic web page, web server and hosting of a website.
• Web Browsers: Introduction, commonly used browsers