BIG DATA & DATA ANALYSIS
Practical Questions
1. Create two excel file which store the details of the employees personal details, official
details, based on the joining details of the employee and the increment given predict list
of employee whether promotion can be given or not.
2. Create an excel file to store the details of the patients health details,
a. Predict whether the user is health or not based on the health reports.
b. Prediction should be done based on the normal values [i.e: BMI, weight, BP,
Cholestrol etc]
3. Read two matrix and perform all the matrix operations like addition, subtraction,
multiplication, division, transpose.
Assign name for the rows and columns
4. Create multiple vector, read all the vectors, store in a data frame and perform all the
operations and conditions based on the vector.
a. Assign new name to the data frame
b. Attach the new column
c. Print the output in the new column based on some conditions
5. Create an excel file which contains the sale details of 3 years in a particular industry.
a. Represent the details in the form of histogram, barplot, boxplot
6. Create an excel file which stores the result details of the students of MCA. Predict the
next year result based on the criteria like [Theory assignment, Practical assignment, Class
performance, attendance, etc ]. Plot the scatter plot of the performance of the students.
7. Write the R code which store the player information like Name, Team, No of times has
played, No of goals scored till date.
a. Store the details in the .csv file
b. Display the details of a single player by entering the name
c. Display the full details of a player who has secured maximum score.
d. Display the average score of each team.
e. Update the score of a particular team and store the details in .csv through R
8. Write the R code to store the student’s examination details like roll_no, name, semester,
sub1_marks, sub2_marks etc.
a. Displays the detailed mark sheet of particular student by passing the roll_no.
b. Display the list of students who has cleared in all subjects
c. Calculate the total number of failed students
d. Display the total number of students who has secured more than 60%
e. Display the full details of a student who has secured maximum marks.
9. Perform the list of operations for the following:
a. List the objects in memory.
b. Clear the screen.
c. Declare variables x, y and assign values of 5 and 8 to x and y.
d. Perform simple calculations like addition, subtraction, division, multiplication etc.
on x and y.
e. Print the values of variables on screen.
f. Assign five distinct values to z.
g. Assign sequential value from 1 to 20 to t.
h. Declare an array a.
i. Input multiple values from the user at prompt and store it in c.
j. Show the data types of all objects on screen.
k. Sort the values in descending order.
l. Find out the sum, max, min, diagonal element of matrix.
m. Find out the working directory and change it.
n. Remove x and y objects from memory.
o. Print only odd numbers of series.
10. Create a matrix of 3 x 3 and make layout, and print the data in the layout.
11. Generate a graphical image by using all plot, define the title, x-axis, y-axis, x limit and y-
limit of a graph for a .csv file?
12. Retrieve the data from the .csv file
a. Normalize the data
b. Represent in a graphical form
c. Specify x-axis, y-axis, x-limit, y-limit, include color to the graph, change the plot
style
13. Use the lattice library and display the graphical image of all lattice form
14. Generate the .csv file, create different models and specify the,
a. Summary of different models
b. Find the residual, co-efficient, fitted and AIC.