{"id":47287,"date":"2022-03-31T08:03:53","date_gmt":"2022-03-31T08:03:53","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/jupyter-computer-science-homework-help\/"},"modified":"2022-03-31T08:03:53","modified_gmt":"2022-03-31T08:03:53","slug":"jupyter-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/jupyter-computer-science-homework-help\/","title":{"rendered":"Jupyter | Computer Science homework help"},"content":{"rendered":"<div>\n<p>\u00a0Create a Jupyter notebook containing a title of \u201chomework 2\u201d, your name, and the course CPSMA 4313. Load any libraries you will use in a code block at the beginning.\u00a0<\/p>\n<p>1. Gather the data from a fitbit provided on Kaggle and provided in the github repo for this course. The link is provided here <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/raw.githubusercontent.com\/nurfnick\/Data\">https:\/\/raw.githubusercontent.com\/nurfnick\/Data<\/a> Viz\/main\/Activity Dataset V1.csv. I have used \u2018quotes\u2019 when discussing a column in the dataset.\u00a0<\/p>\n<p>(a) (10 points) Store the data as a pandas dataframe. Examine each datatype and comment on the appropriateness of each.\u00a0<\/p>\n<p>(b) (10 points) Remove the column that repeats the indexes and is \u2018unnamed\u2019 as a column.\u00a0<\/p>\n<p>(c) (10 points) Clean the column names to remove the unit declaration, (%), using regular expressions. The column name should not have any trailing spaces after cleaning. You will only receive partial credit for simply renaming columns without using regular expressions.\u00a0<\/p>\n<p>(d) (10 points) Convert \u2018activity day\u2019 column into a datetime format.\u00a0<\/p>\n<p>(e) (10 points) Impute \u2018total steps\u2019 by replacing the \u2018NaN\u2019s with an appropriate number of steps. Convert to appropriate datatype.\u00a0<\/p>\n<p>(f) (10 points) Convert non-empty \u2018avg pace\u2019 into a float that is still representative of the information contained in the column. Recall that there are 60 seconds in one minute so 3:30 is equivalent to 3.5 minutes.\u00a0<\/p>\n<p>(g) (10 points) Group data by \u2018workout type\u2019 and find the mean, median, count and standard deviation of \u2018calories\u2019.\u00a0<\/p>\n<p>(h) (10 points) Create an indicator column that identifies if the activity achieved 30% or more \u2018aerobic\u2019 activity.\u00a0<\/p>\n<p>(i) (10 points) Which day of the week (Monday, Tuesday, etc.) and \u2018workout type\u2018 has the maximum of the \u2018max cadence\u2019.\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0Create a Jupyter notebook containing a title of \u201chomework 2\u201d, your name, and the course CPSMA 4313. Load any libraries you will use in a code block at the beginning.\u00a0 1. Gather the data from a fitbit provided on Kaggle and provided in the github repo for this course. The link is provided here https:\/\/raw.githubusercontent.com\/nurfnick\/Data [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-47287","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/47287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=47287"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/47287\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=47287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=47287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=47287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}