Sem: NOV-2024 Maximum Marks: 50 Examination: End Exam Date:1/12/2024 Duration: 2.5hrs
Programme code: 18 Programme: MBA for Working Executive	Class: FY	Semester: Batch- 2023-24 (ATKT-2)
College: K. J. Somaiya Institute of Management	Name of the department/Section/Center: DST
Course Code: 117P18C104	Name of the Course: Data Science Using Python
Instructions: 1. Question No.1 is compulsory. 2. Answer any four from Q2. to Q6. 3. Try to write the output without using Python editors. 4. Do not mix up sub questions. 5. Simple Calculator is allowed.

Question No.	Max. Marks
Q1.	Discuss in detail the various string manipulation methods available in Python. Explain at least ten methods with example.	(10)
Q2.	a) Explain in detail about i) Creating a dictionary (ii) Accessing values in a dictionary (iii) Updating dictionary (iv) Deleting elements from dictionary b) What is a function in Python? What is the difference between user-defined function and built-in function?	(05) (05)
Q3.	a) Explain types of operators with an example.	(10)
Q4.	a)Write the output for the following if the variable fruit=’banana’ : i)fruit[:3] ii) fruit[3:] iii) fruit[3:3] iv) fruit[:] v) fruit[:-1] b) What is the difference between numpy array and python lists? Explain with an example.	(05) (05)
Q5.	Explain in detail about lists, list operations and list slices.	(10)
Q6.	a) What is Pandas in Python? Define DataFrame in Pandas with an example? b) What is the output for the following code? i) import pandas as pd data = [110,202,303,404,550,650] df = pd.DataFrame(data, columns=['Amounts']) print(df) ii) import pandas as pd df = pd.DataFrame({"A":[420,380,390],"B":[50,40,45]}) df["c"]=df["A"]*df["B"] print(df) iii) import pandas as pd dict = {'Name': ['Kate', 'Harry', 'Sheila'], 'Age': [10, 14, 12], 'M1': [85, 77, 91]} df = pd.DataFrame(dict) print(df) print(df.iloc[[0, 2]])	(04) (06)