ICT233 TUTOR-MARKED ASSIGNMENT (TMA) This task is price 24% of the closing imprint for ICT233, Data Programming. The decrease-off date for this task is Thursday, 12 March 2026, 2355 hours. Repeat to College students: You would be to incorporate the following particulars for your submission: Course Code, Title of the TMA, SUSS PI No., Your Establish, and Submission Date. 1. Please present answers into the given template ICT233_TMA_JAN25_STUDENT.ipynb between the following tags: ############## Your code starts here ############## ############### Your code ends here ############### 2. Please map not regulate the given code in the template, map not add/delete/reduce up any code cell. 3. Please print out (exhaust print() characteristic) your evaluation and insights. 4. If there is any discrepancy between the questions displayed in the template and other folks in the TMA paper (in pdf layout), please check with the TMA paper (in pdf layout) as the source of fact. Dataset Data Necessary Repeat: Please exhaust the dataset located in the folder equipped with the pocket book. There isn’t this kind of thing as a decide to catch it from the URL, as the dataset could perhaps maybe also alternate over time and impact your outcomes. Additionally, the equipped dataset entails minor modifications from the customary source for the capabilities of this pocket book. This dataset comprises information about world electrical energy generation (https://github.com/owid/vitality-recordsdata)from varied sources and international locations. It’s miles precious for analysing global vitality dispositions, renewable vs non-renewable sources, and electrical energy generation patterns all the procedure in which by totally different international locations and regions. Resolution all questions Query 1 (74 marks) Targets Realize dataset with recordsdata scientist mindset. Realize and fabricate computation logic and routines in Python. Assess exhaust of Python solely and Python recordsdata structures to include extract, load, and transformation operations. Assess exhaust of Pandas dataframe to include extract, load, transformation and calculation operations. Structure code in appropriate suggestions (capabilities), looping and prerequisites. Originate how to include extract, load, transformation and calculation operations on dataset. Conduct visualization in a suitable manner. Data Cleaning and Exploratory Data Diagnosis (EDA) on World Electrical energy Technology Data (a) Lacking Values Diagnosis 1. Overall Data Completeness Summary Calculate the following: Complete preference of cells in the dataset: (n_columns): n_rows × n_columns Complete preference of missing values: Σ (missing values per cell) Overall recordsdata completeness percentage: ((Complete Cells – Complete Lacking) / Complete Cells) × 100 Overall missing charge percentage: 100 – Overall Completeness (%) 2. Columns with Lacking Values Filter and conceal solely the columns with missing values (i.e., missing count > 0). Comprise the following indispensable functions: Column name. Depend of missing values. Percentage of missing values. 3. Total vs Incomplete Data Write code to: Depend and conceal the preference of total data (rows and not using a missing values) and their percentage. Depend and conceal the preference of incomplete data (rows with a minimal of one missing cost) and their percentage. 4. Distribution of Lacking Values per Memoir Write code to analyse and conceal the distribution of missing values all the procedure in which by incomplete data. Particularly: Depend the preference of data with 1, 2, 3, and plenty others., missing values. Repeat the outcomes in a readable layout. (5 marks) (b) Analyse the metadata in recordsdata/owid-vitality-metadata.csv to search out out appropriate recordsdata sorts for all columns in the most major dataset. Repeat that working out the metadata is indispensable for all subsequent questions. (3 marks) (c) Which high 5 international locations generate perhaps the most electrical energy in 2024 (other than regions like ‘Europe’ and country groups like ‘Excessive-earnings international locations’)? (4 marks) (d) Designate a line attach displaying the model of total electrical energy generation of the discontinue 5 international locations from Query 1(c) over time. Scheme TWO (2) insights from the attach. (4 marks) (e) Originate a visualization to visualize the electrical energy generation by source for China and the United States from 2010 to 2024. Present TWO (2) insights in accordance to the chart. (8 marks) (f) Originate a visualization to visualize the electrical energy generation by source for China and the United States from 2010 to 2024, however this time normalize the data by inhabitants. Present TWO (2) insights in accordance to the chart. (5 marks) (g) Originate a visualization to visualize the electrical energy generation by source for China and the United States from 2010 to 2024, however this time normalize the data by GDP. Present TWO (2) insights in accordance to the chart. (5 marks) (h) To analyse and address the followings: Which country (other than regions and country groups) has the absolute best decrease in fossil electrical energy generation per capita between 2010 and 2024? For this country, pick up the replaceable vitality source that has elevated perhaps the most in electrical energy generation per capita all the procedure in which by the identical interval. Present the name of the vitality source and the amplify in generation per capita. (5 marks) (i) To analyse and include the followings: Visualize nuclear electrical energy generation of all international locations (other than regions and country groups) on an world map from 1965 to 2024 the usage of Plotly visualization library (https://plotly.com/python/choropleth-maps). Repeat that the sage’s minimal and most values can pick up to restful be global as adversarial to year-particular. Present TWO (2) insights in accordance to the visualization. (7 marks) (j) Originate a visualization to whine how electrical energy carbon depth (gCO₂/kWh), carbon_intensity_elec, relates to the a part of fossil electrical energy (%), fossil_share_elec, and part the insights on how this relationship has shifted over time. (5 marks) (okay) Which international locations reduced electrical energy carbon depth perhaps the most without lowering total electrical energy question from 2010 to 2024? (5 marks) (l) Which low-carbon electrical energy technologies (nuclear, hydro, photo voltaic, wind, bioenergy, and totally different renewables) are most strongly connected to reductions in electrical energy carbon depth between 2010 and 2024? Utilize a sturdy regression model (https://www.statsmodels.org/staunch/rlm.html#technicaldocumentation) with M = sm.sturdy.norms.HuberT() to seek the relationship between reductions in electrical energy carbon depth and adjustments in electrical energy generation from low-carbon technologies. Deal with the reduce value in electrical energy carbon depth as the dependent variable (y) and the adjustments in generation from low-carbon technologies as the fair variables (X). Primarily based mostly on the model summary, name the technologies with the superb absolute coefficient values, noting that optimistic coefficients conceal that increases in generation from those technologies are connected to reductions in electrical energy carbon depth, and that p-values below 0.05 conceal statistically major associations. (7 marks) (m) How unequal is gather entry to to low-carbon electrical energy all the procedure in which by international locations with totally different earnings phases in 2024? You would also exhaust data for international locations whose names own the word “earnings” and visualize the distribution of low-carbon electrical energy consumption per capita all the procedure in which by totally different lowcarbon vitality sources and earnings phases the usage of a suitable attach and present the insights. (6 marks) (n) Are electrical energy systems converging globally in carbon depth? Per year, compute the coefficient of variation (CV = neatly-liked deviation / mean) of electrical energy carbon depth all the procedure in which by all international locations (other than regions and country groups). Designate a line attach to visualize the model of CV over time. Present one perception in accordance to the attach. (5 marks) Query 2 (26 marks) Targets: Realize dataset with recordsdata scientist mindset Originate computation logic and routines in Python Conduct visualization in a suitable manner Assess exhaust of Pandas dataframe to include extract, load, transformation and calculation operations Originate how to include extract, load, transformation and calculation operations on dataset Assess the fabricate and exhaust of database ORM / SQLite how to include extract, load, transformation and calculation operations (a) Establish the discontinue ten international locations (other than regions and country groups) with the absolute best rep electrical energy imports as a a part of question, net_elec_imports_share_demand, in 2024, the usage of: Pandas SQL (SQLite) SQLAlchemy ORM (9 marks) (b) Attain electrical energy-import-dependent international locations decarbonize sooner or slower? Compare 2024 in opposition to 2010 to realize a favorable and logical conclusion. Conduct the evaluation the usage of: Pandas SQL (SQLite) SQLAlchemy ORM Present a favorable and logical conclusion in accordance to your findings. A country is believed to be electrical energy-import-dependent if its rep electrical energy imports as a a part of question, net_elec_imports_share_demand, is bigger than 0% in 2010. The decarbonization charge could perhaps maybe also be measured by carbon_intensity_elec_2010 – carbon_intensity_elec_2024 / (2024 – 2010). (17 marks) —-END OF ASSIGNMENT— Reference Provide ICT233_TMA_JAN25_STUDENT.ipynb owid-vitality-metadata.csv owid-vitality-recordsdata.csv ict_233-01_v2.pdf ict_233-02_v2.pdf ict_233-03_v2.pdf ICT233_S4_V2.pdf ICT233_S5_V2.pdf ICT233_S6_V2.pdf Write My Task Receive Legit SUSS ICT233 Task Enhance Presently time Native Singapore Writers Crew 100% Plagiarism-Free Essay Absolute best Satisfaction Price Free Revision On-Time Provide
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER
Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.
We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.
Why Choose AcademicWritersBay.com?
- Our papers are 100% original, custom-written from scratch.
- We’re here to support you around the clock, any day of the year.
- You’ll find our prices competitive and reasonable.
- We handle papers across all subjects, regardless of urgency or difficulty.
- Need a paper urgently? We can deliver within 6 hours!
- Relax with our on-time delivery commitment.
- We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
- Benefit from unlimited amendments upon request to get the paper you envisioned.
- We pledge our dedication to meeting your expectations and achieving the grade you deserve.
Our Process: Getting started with us is as simple as can be. Here’s how to do it:
- Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
- Provide the specifics of your paper in the “PAPER DETAILS” section.
- Select your academic level, the deadline, and the required number of pages.
- Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
- Follow the simple payment instructions and soon, our writers will be hard at work on your paper.
AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.
