CMPF104: Data Cleaning and Preprocessing: Data science and Data Anaytics: Programming For Foundation In Engineering, Assignment, UNITEN, Malaysia
University | Universiti Tenaga Nasional (UNITEN) |
Subject | CMPF104: Programming For Foundation In Engineering |
Data science and Data Anaytics
Download the dataset from BRIGHTEN. If your student ID ends with an odd number, select Concrete_Data_A dataset, and if your student ID ends with an even number, select Concrete_Data_B dataset. Using the Python attributes, function and libraries to solve the following problems.
a) Data Cleaning and Preprocessing:
- Use Pandas to load the dataset. Name the dataframe as concrete_df_XXX.
- Remove ‘Number’ column using .drop() function and visualize the first ten (10)
rows of the data. - Handle any missing values by dropping or replacing the empty cells. Check for missing values using functions like .info() or .isnull().sum()
- Convert the data frame to array, using to_numpy() function.
- Divide the data into two sets of data with division of 80% and 20% for train and test data, respectively. Name the dataset as train_data_XXX and test_data_XXX
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
b) Data Analysis:
- Calculate the correlation between the variables in the dataframe.
- Utilize NumPy and Pandas to calculate summary statistics of the data such as
maximum, minimum, standard deviation, average, median and mode of each
category. - Use Pandas functions like .describe() for an overview of summary statistics and apply NumPy functions for specific calculations.
c) Visualization:
- Use Matplotlib to create visualizations such as line plots for train and test data
across all categories. - Generate histogram plots and box plots for all variables.
- Ensure that the visualizations are clear, informative, and aesthetically pleasing.
- Customize your plots by adding the titles, labels and legends
Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services.
Get Help By Expert
Do you need assistance with CMPF104: Programming For Foundation In Engineering assignments? Our assignment helper in Malaysia offers expert help. We specialize in programming assignment writing to ensure your academic success. Let us handle your coursework while you focus on learning. Invest in your education with our reliable services for top-notch quality and improved performance.
Answer
Recent Solved Questions
- Malaysian Legal System Assignment, UM, Malaysia Walaupun Perlembagaan Persekutuan merupakan undang-undang tertinggi negara, namun ia masih boleh dipinda tertakluk
- SBSF1103: Thinking Skill Essay, OUM, Malaysia A team of five persons is responsible for negotiating the prices of cables that suppliers provide to your company
- BBM207: Human Resource Management Assignment, WOU, Malaysia Describe how the new wage will benefit employees in the urban areas and Discuss the consequences to the economy of Malaysia
- Programming Fundamental Assignment, TU, Malaysia Morgan Stark is a child prodigy just like his father Tony Stark when he was young. At five years old, she self-taught herself
- EER1001: Electrical Services for Facilities Assignment, TP, Malaysia What is Total Connected Load (TCL)?
- Cyhoeddus Research Paper, UON, Malaysia What is the purpose of the statistical test & E.g. the purpose of regression analysis is to estimate the relationship
- LC1204: Non-verbal Communication Assignment, UTB, Malaysia Identify the non-verbal cues in a particular context/setting e.g., classroom setting or family gathering, or official event
- Special and Inclusive Education MA Assignment, UNM, Malaysia: You are required to provide a full bibliographic list of academic citations using the Harvard Referencing system
- CSEB2113: Programming 1 Assignment, TNU, Malaysia Write C++ statements to perform the following tasks: Declare a variable name my Class of type integer in an array form with size 20
- DPM10013: Principles of Marketing Assignment, PM, Malaysia ABC Mart is a 24-hour convenience store. It serves nearby residential communities and commercial and business