top of page

Data Manipulation and Visualization Assignment Solution | Sample Assignment



Are you facing a complex data manipulation and visualization assignment and in need of expert guidance? Designing and developing a prototype application to format, clean, and generate specific outputs from a given dataset can be a daunting task. At Codersarts, we understand the challenges of handling data and creating meaningful insights from it. In this blog post, we'll take you through a sample assignment that involves tasks like loading, cleaning, and processing data using Python and advanced libraries like NumPy, pandas, Seaborn, and Matplotlib.


What do we offer ?

Our team of experienced programmers and data scientists can provide you with a comprehensive solution to this assignment, ensuring that you not only meet the functional and technical requirements but also gain a deep understanding of the underlying principles. We specialize in offering expert guidance and solutions for assignments like these, and our goal is to help you succeed in your data-related endeavors.


Get Expert Solution

We providing the sample assignment below. If you are in need of a solution for this assignment or require assistance with similar tasks, feel free to contact us. We specialize in offering solutions for assignments of this nature and are here to support you in achieving your academic or professional goals. Our expertise extends beyond this sample assignment, so whether you have data manipulation and visualization tasks, programming challenges, or any other related assignments, CodersArts is your go-to source for reliable solutions and expert guidance.


Sample Assignment


1. Assessment Background/Scenario

You should use the client brief and given data set for your formative work. As this brief is identical to the summative you should not share or distribute your work with your peers. Your summative work should be all your own work.


Client Brief

This document provides the client brief which should be used for the development of a single program or a collection of related programs, for submission with the final summative report.

You have been asked to design and develop a prototype application that demonstrates how data from the given data set can be formatted, cleaned, and used to generate specific outputs (as listed below).


Functional requirements

The application should provide the following functionality:

  • A means to load the initial data set (which consists of three CSV files) and translate it into a suitable format, either XML, or JSON or an entity relationship structure (not CSV)

  • A means to back up the suitable format using either files or a database. This should preserve the current state of the data when the program is closed, and make it available when the program is reopened.

  • A process for cleaning and preparing the initial data set, managing inconsistencies, errors, missing values and any specific changes required by the client (see below).

  • A graphical user interface(s) for interacting with the data that enables the user to:

  • Load and clean an initial data set (from the CV format)

  • Load and save a prepared data set (from its translated format)

  • Use the prepared data set to generate output and visualisations

  • Manipulate the range of values used to generate output and visualisations

It should be assumed that this program will be able to handle other sets of data generated from the same source, i.e. data with the same column row headings but containing different values and anomalies. However, the application is not required to be generic (work with multiple unknown data sets). Given this best practice regarding code reuse, encapsulation and a well-defined programming interface should be applied where applicable.


Data manipulation and outputs

The client initially wants the application to perform the following actions on the data:

  1. Outputs should not include any data from DAB Radio stations that have the following ‘NGR’ : NZ02553847, SE213515, NT05399374 and NT252675908

  2. The ‘EID’ column contains information of the DAB multiplex block E.g C19A. Extract this out into a new column, one for each of the following DAB multiplexes:

  3. all DAB multiplexes, that are , C18A, C18F, C188

  4. join each category, C18A, C18F, C188 to the ‘ NGR’ that signifies the DAB stations location to the following: ‘Site’, Site Height, In-Use Ae Ht, In-Use ERP Total

  5. Please note that: In-Use Ae Ht, In-Use ERP Total will need the following new header after extraction: Aerial height(m), Power(kW) respectively.

  6. The client initially needs information to generate the following and output the results using appropriate representation:

  7. Produce the mean, mode and median for the ‘In-Use ERP Total’ from the extracted DAB multiplexes extracted earlier: C18A, C18F, C188

  8. For ‘Site Height’ more than 75

  9. For ‘Date’ from 2001 onwards

  10. Produce a suitable graph that display the following information from the three DAB multiplexes that you extracted earlier: C18A, C18F, C188: ‘Site’, ‘Freq’, ‘Block’, ‘Serv Label1’, ‘Serv Label2’, ‘Serv Label3’, ‘Serv label4’,’Serv Label10’

You may need to consider how you group this data to make visualisation feasible

  1. Determine if there is any significant correlation between the ‘Freq’, ‘Block’, ‘Serv Label1’, ‘Serv Label2’, ‘Serv Label3’, ‘Serv label4’,’Serv Label10’ used by the extracted DAB stations. You will need to select an appropriate visualisation to demonstrate this.

Non-functional requirements

  • The GUI interface must be able to provide appropriate feedback to confirm or deny a user’s actions

  • The application must be able to manage internal and user-generated errors

Technical requirements

  • The application is built using Python 3.7 - 3.10

  • The application uses one or more of the advanced APIs introduced on this module such as: NumPy, pandas, Seaborn, Matplotlib. It should NOT use alternative APIs for this functionality, however Python core libraries can be used to support where applicable, such as support for a database.

  • The application runs within the anaconda environment using a Jupyter notebook

  • The application or its parts do not run concurrently, do NOT use Python threads

The requirements specified here are the constraints within which you need to produce your development. They are not negotiable with the client.

  1. Assessment Task(s)

Given the client brief above, produce a suitable software solution that meets the specified requirements as either a single program, or a series of clearly identifiable programs.

NOTE: Failure to submit the program(s) will result in a zero grade.

From this development produce a structured design report (using the given template) that addresses a series of focus questions. These ask you to discuss your design decisions and demonstrate the underpinning theoretical aspects in the context of your software development. Code samples should be extracted from your software development where requested to demonstrate specific algorithms and interactions. You should support your discussion with appropriate reference to relevant sources using the correct citation and reference structure as indicated in the guide to IEEE referencing system.


Report contains 3 sections as follows:

The report consists of three sections, each containing specific questions targeting what needs to be addressed. In each section is a maximum word count and this should be adhered to. Your report should clearly identify which question you are addressing. Ensure you keep your code samples separate from your explanations. The sections contribute to the module learning outcomes as follows:


Section 1: Theory supported by code samples (50%, 1400 words plus code samples)

Evidence for learning outcome: Demonstrate critical understanding of the theory and application of advanced programming techniques; Design and implement programs for real world problems.


Section 2: Design decisions supported by code samples (40%, 1200 words plus code samples)

Evidence for learning outcome: Communicate design decisions for the selection, storage and manipulation of data; Design and implement programs for real world problems.


Section 3: Reflection on the ethics, moral and legal aspects (10%, 400 words)

Evidence for learning outcome: Critically evaluate the legal and ethical impact of software developments within real world contexts.

  1. Deliverables

Your assignment should be laid out following the formatting guidelines that are specified in the ‘Submission Formatting’ page in Canvas.

You should make two file submissions as follows:

  • A completed report answering the given questions as a single file in either .docx or .pdf format. This should NOT be included in the zipped file and should not exceed any specified word/page counts.

  • A single zipped file containing your program or programs. If a database has been used you should produce a file dump of the table structure to include here. This should NOT contain the original data set.

NOTE: Failure to submit the program(s) will result in a zero grade.

The report must adhere to the word count limits stated for EACH question and the page limit for the appendices.


Code samples:

All code samples submitted in your report should be extracted from your program verbatim. Those that are not will not contribute towards your grade. Code samples do NOT contribute to your word count. You should make sure they very clearly target what is requested, and submitting general or broad ranges of code may be subject to penalties. For example, if you were asked to demonstrate where a closure has been used within your code, you would not be demonstrating this by submitting a complete program that contains a closure. You may add code style comments to your code samples to help target what you are showing, but should not change the structure of the code from your software submission.


Using a database:

Where you have opted to use an SQL or relational database (other than Mongo) include after your list of references the following:

  • Name of database and link to download (install package)

  • Version number of the database used

  • The name of the code file (Python class/Jupyter Notebook) that creates and populates the database

  • The point in your code where local host and the port are set (make this clear)

You should make sure that your submitted code contains all the code required to setup and populate your database via a local host connection.


General submission guidelines:

  • Present your answers on A4 pages, with a minimum 12 point font (14 point for headings), minimum 120% line spacing (what Word calls “Multiple 1.08”), and margins of at least 2 cm on either side.

  • All images must be of a size/quality that the details are viewable within the document. Images will not be scaled to identify blurred or small text.

  • Your code should be focused on the selected production and not the whole program, and be easily identifiable as a solution to the production problem. Well commented and structured code is more likely to be easy to follow and receive feedback.

Referencing

You are required to use the IEEE referencing style for citing books, articles, and all other sources (such as websites) used in your assignment.

Good referencing is essential in order to meet the standards of academic integrity set by the University. All your sources must be acknowledged, regardless of whether you included direct quotes or not. Visit your Academic Integrity Tutorial module in Canvas for additional guidance on effective referencing.


Deliverables You Can Expect


We understand the complexity of assignments like the one presented above, and we're here to make the process as smooth as possible for you. When you choose to work with us, we provide all the essential resources and expertise you need to excel in your assignment. Our comprehensive support includes access to well-structured code samples, detailed explanations, and hands-on assistance to ensure you understand every aspect of the task. We also offer guidance on theoretical concepts and design decisions, ensuring your solution is not only correct but also well-reasoned and practical. Furthermore, our team will assist you in addressing ethical, moral, and legal considerations, providing a holistic approach to your project. You can count on us to deliver a complete, well-documented solution that meets all the specified requirements. So, if you're looking for a reliable partner to tackle assignments like these, remember that CodersArts has you covered.


How CodersArts Can Help You Overcome Challenges

CodersArts provides tailored solutions to address these challenges:

  • Expert Guidance: Our experienced team of experts offers step-by-step guidance on designing and developing prototype applications to format, clean, and generate specific outputs from complex datasets.

  • Efficient Data Handling: We teach you efficient data manipulation techniques to optimize the performance of your application.

  • Error Resolution: Get prompt assistance in debugging and resolving errors in your code and data processing.

  • Personalized Support: Receive one-on-one support to address your unique challenges in this assignment and other similar tasks.


Why Choose CodersArts

  • Expertise: At CodersArts, our team comprises experts in data manipulation and advanced programming with extensive industry experience.

  • Customized Solutions: We tailor our guidance and solutions to your specific skill level and the requirements of your project, ensuring that you receive personalized support.

  • Timely Assistance: We understand the importance of meeting deadlines, and we provide prompt and reliable support, so you can stay on track with your assignments.

  • Comprehensive Learning: Beyond helping you complete your assignments, we are committed to ensuring that you fully grasp the underlying concepts and principles, equipping you for future challenges.

  • Affordable: We offer competitive pricing, making expert assistance in data manipulation and programming accessible to students and professionals alike.


If you're in need of a solution for this assignment or require assistance with similar tasks, don't hesitate to reach out to us. You can contact us via email at contact@codersarts.com, and we're here to provide you with the best solutions to meet your academic or professional needs.


bottom of page