Answered step by step
Verified Expert Solution
Question
1 Approved Answer
in python Coding Exercise For the next upcoming weeks, our knowledge of pandas & basic Python syntax will be tested as we implement data-pipelines and
in python Coding Exercise For the next upcoming weeks, our knowledge of pandas & basic Python syntax will be tested as we implement data-pipelines and vatious. analyses. To refresh our pandas skills, let's implement the following non-trivial lines of pseudocode to reveal information tegarding our dataset describing top-soccer/football scorers internationally. To find out more information regarding this dataset, check out: bthsi///wmwkaggle.com/datasets/mohamedhanyyy/toc focthall ieaguse- scorers L1 inport pandas as pa - Load in your dataset located in data/scorers, civ of = pd.read_ssv("scorersicsu") "print out the first 3 row of your datafrare df, head(? I 1 e print out summary statisties regarding tbis datafrano df. describe(?) mean-goals w of [ Goole ] inean( ) foancegoals: I I Ugrint out kenecal info;dn this datafrated I) notice why nissing values in. the non-malt count coluent df. Info;? [1 " print out general info an this datafeame If notice any aissing values in the non-nall count coluan? di. info() cclass 'pandas. core. frame. DataFfate'? RangeIndex: 660 entries, to 659 Data colunns (total 13 colunns)? * what do you natice about the countries listed. Apy enrors? countries = df a coupbyc "rountry k ). countries[ Foals" ]. moan(1) dodye avr eoalt hnead() A group players by country \& year-fron datafrane "above_avg. gosis" and conpute the rotal goals foe each country country year = above_avg, gonls. groupby ([" Country", "Year"]) "Gals" licount () which country had the highest onount of above ove scorers? country year
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started