ICT233\u00a0 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)\u00a0 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 \u00d7 n_columns Complete preference of missing values: \u03a3 (missing values per cell) Overall recordsdata completeness percentage: ((Complete Cells \u2013 Complete Lacking) \/ Complete Cells) \u00d7 100 Overall missing charge percentage: 100 \u2013 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. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (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) \u00a0(c) Which high 5 international locations generate perhaps the most electrical energy in 2024 (other than regions like \u2018Europe\u2019 and country groups like \u2018Excessive-earnings international locations\u2019)? (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. \u00a0(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\u2019s 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\u2082\/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 \u201cearnings\u201d 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 \u2013 carbon_intensity_elec_2024 \/ (2024 \u2013 2010). \u00a0(17 marks) \u2014-END OF ASSIGNMENT\u2014 Reference Provide\u00a0 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<\/p>\n","protected":false},"excerpt":{"rendered":"
ICT233\u00a0 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-29980","post","type-post","status-publish","format-standard","hentry","category-solutions"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/29980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/comments?post=29980"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/29980\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=29980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=29980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=29980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}