B.Sc. (Data Science) II-Year I-Semester
BSDS-303- Paper-III :Data Engineering with Python
UNIT – I
Data Science: Data sets, Data variables, understanding of Datasets, Data Analysis Sequence, Data Acquisition Pipeline, Report Structure. Files and Working with Text Data: Types of Files, Creating and Reading Text Data, File Methods to Read and Write Data, Reading and Writing Binary Files, The Pickle Module, Reading and Writing CSV Files, Python os and os.path Modules. Working with Text Data: JSON and XML in Python.
UNIT – II
Working with Text Data: Processing HTML Files, Processing Texts in Natural Languages. Regular Expression Operations: Using Special Characters, Regular Expression Methods, Named Groups in Python Regular Expressions, Regular Expression with glob Module. Working with Databases: Setting Up a MySQL Database, using a MySQL Database: Command Line, Using a MySQL Database, Taming Document Stores: MongoDB
UNIT – III
Working with Tabular Numeric Data (NumPy with Python): Introduction to NumPy, NumPy Arrays Creation Using array() Function, Array Attributes, NumPy Arrays Creation with Initial Placeholder Content, Integer Indexing, Array Indexing, Boolean Array Indexing, Slicing and Iterating in Arrays, Basic Arithmetic Operations on NumPy Arrays, Mathematical and Statistical Functions in NumPy, Changing the Shape of an Array, Stacking and Splitting of Arrays, Broadcasting in Arrays.
UNIT – IV
Pandas: Introduction to Pandas, Working with Pandas Data Structures: Data Series and Frames, Renaming and Reshaping Data Using Pandas, Handling Missing Data using Pandas, Merging the Data using Pandas, Ordering and Describing Data, Transforming Data, Taming Pandas File I/O (Explanation of data exchange between frames and series). Plotting: Introduction to Basic Plotting with PyPlot, Initializing the Plots object, Types of Plots Getting to Know Other Plot Types, Mastering Embellishments, Plotting with Pandas.
B.Sc. (Data Science) II-Year II-Semester
BSDS-404- Paper-IV:Programming in Java
UNIT – I
Introduction: Java Essentials, JVM, Java Features, Creation and Execution of Programs, Data Types, Structure of Java Program, Type Casting, Conditional Statements, Loops, Classes, Objects, Class Declaration, Creating Objects.
UNIT - II
Methods: Declaration and Invocation, Method Overloading, Constructors – Parameterized Constructors, Constructor Overloading, Cleaning-up unused Objects. Class Variables &Method-static Keyword, this Keyword, One-Dimensional Arrays, Two-Dimensional Arrays, Command-Line Arguments, Inner Class. Inheritance: Introduction, Types of Inheritance, extends Keyword, Examples, Method Overriding, super, final Keyword, Abstract classes, Interfaces, Abstract Classes Verses Interfaces. Packages: Creating and Using Packages, Access Protection, Wrapper Classes, String Class, String Buffer Class.
UNIT – III
Exception: Introduction, Types, Exception Handling Techniques, User-Defined Exception. Multithreading: Introduction, Main Thread and Creation of New Threads –By Inheriting the Thread Class or Implementing the Runnable Interface, Thread Lifecycle, Thread Priority and Synchronization. Input/Output: Introduction, java.io Package, File Streams, File Input Stream Class, File Output Stream Class, Scanner Class, Buffered Input Stream Class, Buffered Output Stream Class, Random Access File Class.
UNIT - IV
Applets: Introduction, Example, Life Cycle, Applet Class, Common Methods Used in Displaying the Output (Graphics Class). Event Handling: Introduction, Types of Events, Example. AWT: Introduction, Components, Containers, Button, Label, Checkbox, Radio Buttons, Container Class, Layouts. Swings: Introduction, Differences between Swing and AWT, JFrame, JApplet, JPanel, Components in Swings, Layout Managers, JTable.
B.Sc. (Data Science) II-Year I-Semester
BSDS-303-P Practical-III Data Engineering with Python (Lab)
List Practical’s:
1. Write programs to parse text files, CSV, HTML, XML and JSON documents and extract relevant data. After retrieving data check any anomalies in the data, missing values etc.
2. Write programs for reading and writing binary files
3. Write programs for searching, splitting, and replacing strings based on pattern matching using regular expressions
4. Design a relational database for a small application and populate the database. Using SQL do the CRUD (create, read, update and delete) operations.
5. Create a Python MongoDB client using the Python module pymongo. Using a collection object practice functions for inserting, searching, removing, updating, replacing, and aggregating documents, as well as for creating indexes
6. Write programs to create Numpy arrays of different shapes and from different sources, reshape and slice arrays, add array indexes, and apply arithmetic, logic, and aggregation functions to some or all array elements
7. Write programs to use the Pandas data structures: Frames and series as storage containers and for a variety of data-wrangling operations, such as:
• Single-level and hierarchical indexing
• Handling missing data
• Arithmetic and Boolean operations on entire columns and tables
• Database-type operations (such as merging and aggregation)
• Plotting individual columns and whole tables
• Reading data from files and writing data to files
B.Sc. (Data Science) II-Year II-Semester
BSDS-404-P Practical-IV Programming in Java (Lab )
List of Practical's:
1. Write a java program to find the largest of ‘n’ natural numbers.
2. Write a java program to find whether a given number is prime or not.
3. Write a menu driven program for following: Display a Fibonacci series and Compute Factorial of a number.
4. Write a java program to check whether a given number is odd or even.
5. Write a java program to check whether a given string is palindrome or not.
6. Write a java program to print the sum and product of digits of an Integer & reverse the Integer.
7. Write a program to create an array of 10 integers. Accept values from the user in that Array. Input another number from the user and find out how many numbers are equal to the number passed, how many are greater and how many are less than the number passed.
8. Write a java program that will prompt the user for a list of 5 prices. Compute the average of the prices and find out all the prices that are higher than the calculated average.
9. Write a java program in java to input N numbers in an array and print out the Armstrong numbers from the set.
10. Write java program for the following matrix operations: Addition of two matrices and Transpose of a matrix
11. Write a java program that computes the area of a circle, rectangle and a Cylinder using function overloading.
12. Write a java program for the implementation of multiple inheritance using interfaces to calculate the area of a rectangle and triangle.
13. Write a java program to create a frame window in an Applet. Display your name, address and qualification in the frame window.
14. Write a java program to draw a line between two coordinates in a window.
15. Write a java program to display the following graphics in an applet window. a. Rectangles b. Circles c. Ellipses d. Arcs e. Polygons
16. Write a program that reads two integer numbers for the variables a and b. If any other character except number (0-9) is entered then the error is caught by Number Format Exception object. After that ex.get Message () prints the information about the error occurring causes.
17. Write a program for the following string operations: a. Compare two strings b. concatenate two strings c. Compute length of a string.
18. Create a class called Fraction that can be used to represent the ratio of two integers. Include appropriate construction.