munotes®
Sign in
Home / Syllabus / B.Sc. (Data Science) / FY BSc Data Science / Semester 2 / Major Practical 2

B.Sc. (Data Science) Major Practical 2 Syllabus - Mumbai University

This is the FY BSc Data Science syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.

Major Practical 2 Syllabus.pdf
Major · Semester 2 · FY BSc Data Science · 2 credits · 50 marks

Loading syllabus...

Syllabus for Major Practical 2

Major · Semester 2 · FY BSc Data Science · 2 credits · 50 marks

Module I: Practical No. 1

  • a Write a python code to demonstrate concatenating tuples to nested tuples.
  • b Write a python code to sort the nested tuple using sorted() function.
  • c Write a python code to demonstrate unpacking of nested tuples.
  • d Write a python code to clone list using slice operator. Practical No.2
  • a Write a Python code to Find the size of Tuples.
  • b Write a Python code Find sum of tuple elements.
  • c Write a Python code to remove duplicate element from tuple.
  • d Write a Python code to Flatten tuple of list to tuple. Practical No. 3
  • a Write a python code to check immutability property of python tuples.
  • b Write a python code to implement various methods to search and replace operations.
  • c Write a python code to retrieve data from HTML file.
  • d Write a python code to print current date in different format. Practical No. 4
  • a Write a Python code to demonstrate time class.
  • b Write a Python code to use timedelta function to print date.
  • c Write a Python code to use strftime and strptime functions in python.
  • d Write a Python code to count remaining days using date object. Practical No. 5
  • a Write a python code to convert time stamp to date stamp.
  • b Write a python code to develop calendar module.
  • c Write a python code to compare two dates.
  • d Write a python code to create Numpy Array. Practical No. 6
  • a Write a Python code to find minimum elements in array using Numpy.
  • b Write a Python code to find mean of every Numpy array in the given list.
  • c Write a Python code to reverse Numpy array.
  • d Write a Python code to add rows and columns in Numpy array. Practical No. 7
  • a Write a python code to demonstrate basic operations on single array.
  • b Write a python code to create array with 10 elements and slice element from 1 st to 5 th element.
  • c Write a python code to sort an array alphabetically.
  • d Write a python code to create a filter array that will return maximum values from an array. Practical No.8
  • a Write a python code to demonstrate importing pandas libraries and create data frame object.
  • b Write a Python code to create pandas series from a dictionary of values and ndarray.
  • c Write a Python code to perform arithmetic operations on two pandas series.
  • d Write a Python code to add some data in existing series. Practical No. 9
  • a Write a Python code to select the rows where percentage greater than 9b. Write a Python code to join the two given dataframes along rows and assign all data.
  • b Write a Python code to select rows from dataframe based on values in columns.( use relational and logical operators.)
  • c Write python code to filter duplicate rows. Practical No. 10
  • a Write a python code to demonstrate filter pandas series with Boolean arrays.
  • b Write a code to import and export data between pandas and csv files.
  • c Read employee.csv file to create dataframe and perform following operations:
  • i Display Name, Gender and department of employee. ii) Display first 5 and last 5 records from employee.csv
  • d Write a code to import and export data between pandas and MySQL Database.
  • e Write a code to replace all negative values to 0.

Module II: Demonstration with explanation of concept of practical should be

  • added in the beginning for each practical session. Student should practice on different databases during practical. Practical No. 1: Write SQL query for given problem statement.
  • a Viewing all databases
  • b Creating a Database
  • c Viewing all Tables in a Database Practical No. 2: Perform the following Operations.
  • a Creating Tables (With and Without Constraints)
  • b Inserting/Updating/Deleting Records in a Table
  • c Saving (Commit) and Undoing (rollback) Practical No. 3: Perform the following Operations.
  • a Altering a Table
  • b Dropping/Truncating/Renaming Tables
  • c Backing up / Restoring a Database. Practical No. 4: Perform following:
  • a Simple Queries with Where Operators
  • b Where with Keywords and Logical Operators
  • c Simple Queries with Aggregate functions
  • d Queries with Aggregate functions (group by and having clause) Practical No. 5: Perform Queries involving:
  • a Date Functions
  • b String Functions
  • c Math Functions Practical No. 6: Retrieving Data from Multiple Table:
  • a Joining Tables (InnerJoins, Outer-Joins)
  • b Aliases for Table Names Practical No. 7: Write Subqueries:
  • a With IN clause
  • b With EXISTS clause
  • c Handling NULL Practical No. 8: Perform Views commands:
  • a Creating Views
  • b Dropping Views
  • c Selecting from view Practical No. 9 : Perform DCL statements:
  • a Granting permissions
  • b Revoking permissions Practical No. 10 : Use of DDL DML and DCL statement for employee payroll system (Or any other system recommended by teacher)
  • a Identify employee payroll entities
  • b Define and Create Database, tables with constraint
  • c Insert 10 to 20 relevant records to support further queries
  • d Design simple queries using operators and functions
  • e Create Views and perform drop and select view command
  • f Perform grant and revoke commands. 10, 11 Reference and Text Books 1. Programming through Python M. T. Savaliya, R.K Maurya, G.M Magar, Staredu Solutions, 1 st edition (2018) 2. Python DataScience Handbook, Jake VanderPlas, O'Reilly Media, 1 st edition (2016) 3. Let Us Python, Yashwant Kanetkar, BPB publication , 1 st edition (2019) 4. Programming in Python3, Mark Summerfield, Pearson Education, 2 nd edition (2018) 5. Learning Python, LutzM, O’Reilly- Shroff, 5 th edition, 2013. 6. Beginning Python, Magnus LieHetland, Apress, 2 nd edition, 2009. Star Python, Star Certification, Star Certification,1 st , 2018. 7. Fundamentals of Database Systems, Elmasri Ramez and Navathe Shamkant B, Pearson Education 6th Edition, 2010. 8. Database System Concepts Silberschatz, Korth, Sudarshan, McGraw Hill, 5 Edition, 2006. 9. Database Management Systems, Ramakrishna, Gehrke, McGraw‐ Hill, 2007 10. Murach’s MySQL Joel Murach, Murach, 2012. 12 Internal Continuous Assessment: Semester End Examination: 60% 40% 13 Continuous Evaluation through: 30 marks practical exam of 2 hours duration Students are expected to attend each practical and submit the written practical of the previous session. Performing Practical and writeup submission will be continuous internal evaluation. 2.5 marks can be awarded for each practical performance and writeup submission totalling to 50 marks and can be converted to 20 marks. 14 Format of Question Paper: Duration 2 hours. Certified copy of Journal is compulsory to appear for the practical examination Practical Slip: Q1. From Module 1 13 marks Q2. From Module 2 12marks Q3. Journal and Viva 05 marks

Reproduced from the University of Mumbai syllabus for B.Sc. (Data Science) under NEP 2020, in force from the academic year 2024-25. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF 2024 25 DS SEM I & II NEP NEP 2020 syllabus, in force from 2024-25 Read full PDF Read
PDF 2023 24 BSc Data Science Sem V & VI Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read
PDF 2021 22 BSc Data Science Sem III & IV Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read
Report or request
Done!