Data Analysis Using Python — DU B. Voc – Web Designing Previous Year Question Papers

1. (i) What are the different data structures in (ii) Write a Python program to generate n random numbers from the range between I and 30, Gili) Write a short note on the usage of the pip command in Python. (iv) What is normalization? Why is it used? (v) Write a Python program to insert an clement into the given sorted list. (vi) Which command is used to identify the missing values in the data frame? What are the different ways to handle the missing values in the data frame? (vii) What are the different ways to create a dataframe in the Pandas Python library? (vili) What is the difference between tuple and list in (ix) Write the Python command to display the dimension of the Numpy array and display the total number of rows and columns of the Pandas dataframe. (x) Consider the 3-dimonsional array: Arr3d = (I1,2,3.14,5,6).17,8,911. Write the slicing command in Python to have the output as [8,9] and [5] from the given Arr3d. (i) What is Matplotlib? Write the two main purposes of the Matplotlib Python library. What are the different types of graphs in Matplotlib? Write a Python program to plot a Histogram by assuming your own data and explain the various attributes 6) Write the difference between a Histogram and i Bar chart. (i) Describe the steps involved in the proces f Data Analysis. (i) Write a Pylon program 1o check for the presence of a key in the dictionary and print the sum of all its values. (ii) Write a Python program to get the input from the user through a prompt message for a score between 0.0 and 1.0. If the score is out of the range, print a error message. If the score is between 0.0 and 1.0, print a grade according to the given table. (8) Score Grade (i) Write the Python command to compute the correlation of column A with column B in the dataframe namely df. (3) (ii) Write the Python command to sort the df dataframe in descending order of column A. Write the Python command to sort the df dataframe in ascending order of column B. (iii) Write the Python command to calculate the maximum of column A of the df dataframe. (iv) Write the Python command to display the cube of column C of the df dataframe. (3) (v) Write the Python command to replace the value 6 with 3 and 7 with 4 in column C of the df dataframe. (3) (i) Write a Python program to compute the mean, standard deviation, and variance of a given array along with the second axis. Sample output : Original Array: [0 1 2 3 4 5] (i) Write a Python program to plot heatmap using matplotlib? (4) (iii) What is the Pearson Correlation Coefficient? What is the possible range of values obtained in correlation and how is it interpreted? (4) (i) Write a Python program to plot the algebraic equation: 10x+14. (4) (ii) Write a note on multiple subplots with suitable examples. (4) (ii) Write a user-defined function findname (name) where name is an argument in Python to delete a phone number from a dictionary phonebook on the basis of the name, where name is the key. (7)