Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

**USE PYTHON ONLY** Using the following CSV answer the questions below: Goals-Total Saves ShotsShots to- shots Penalties to- on off Shooting shots (inc. Hit Penaltynot

**USE PYTHON ONLY**

Using the following CSV answer the questions below:

Goals-Total Saves ShotsShots to- shots Penalties to- on off Shooting shots (inc. Hit Penaltynot Headed Passes Passing Corners ClearancesClean Goals Savesshots Team GoalstargettargetAccuracy(perc) Blocked)Woodworkgoals scored goals PassescompletedAccuracyTouchesCrossesDribblesTaken TacklesClearancesInterceptionsoff line SheetsBlocksconcededmade ratio Croatia 4 13 12 0.519 0.16 32 0 0 0 2 1076 828 0.769 1706 60 42 14 49 83 56 0 10 3 13 0.81 Czech Republic 4 13 18 0.419 0.129 39 0 0 0 0 1565 1223 0.781 2358 46 68 21 62 98 37 2 1 10 6 9 0.60 Denmark 4 10 10 0.5 0.2 27 1 0 0 3 1298 1082 0.833 1873 43 32 16 40 61 59 0 1 10 5 10 0.66 England 5 11 18 0.5 0.172 40 0 0 0 3 1488 1200 0.806 2440 58 60 16 86 106 72 1 2 29 3 22 0.88 France 3 22 24 0.379 0.065 65 1 0 0 0 2066 1803 0.872 2909 55 76 28 71 76 58 0 1 7 5 6 0.54 Germany 10 32 32 0.478 0.156 80 2 1 0 2 2774 2427 0.874 3761 101 60 35 91 73 69 0 1 11 6 10 0.62 Greece 5 8 18 0.307 0.192 32 1 1 1 0 1187 911 0.767 2016 52 53 10 65 123 87 0 1 23 7 13 0.65 Italy 6 34 45 0.43 0.075 110 2 0 0 2 3016 2531 0.839 4363 75 75 30 98 137 136 1 2 18 7 20 0.74 Netherlands 2 12 36 0.25 0.041 60 2 0 0 0 1556 1381 0.887 2163 50 49 22 34 41 41 0 0 9 5 12 0.70 Poland 2 15 23 0.394 0.052 48 0 0 0 1 1059 852 0.804 1724 55 39 14 67 87 62 0 0 8 3 6 0.66 Portugal 6 22 42 0.343 0.093 82 6 0 0 2 1891 1461 0.772 2958 91 64 41 78 92 86 0 2 11 4 10 0.71 Republic of Ireland 1 7 12 0.368 0.052 28 0 0 0 1 851 606 0.712 1433 43 18 8 45 78 43 1 0 23 9 17 0.65 Russia 5 9 31 0.225 0.125 59 2 0 0 1 1602 1345 0.839 2278 40 40 21 65 74 58 0 0 8 3 10 0.7 Spain 12 42 33 0.559 0.16 100 0 1 0 2 4317 3820 0.884 5585 69 106 44 122 102 79 0 5 8 1 15 0.93 Sweden 5 17 19 0.472 0.138 39 3 0 0 1 1192 965 0.809 1806 44 29 7 56 54 45 0 1 12 5 8 0.61 Ukraine 2 7 26 0.212 0.06 38 0 0 0 2 1276 1043 0.817 1894 33 26 18 65 97 29 0 0 4 4 13 0.76

image text in transcribed

Please answer the following questions:

Find teams that scored more than 6 goals

Select the teams whose name start with a G

Select the first 7 columns

Select all columns except the last 3

Present only the Shooting Accuracy from England, Italy and Russia

. A B 1 Team Goals 2 Croatia 3 Czech Re 4 Denmark 5 England 6 France 7 Germany 8 Greece 9 Italy 10 Netherlar 11 Poland 12 Portugal 13 Republic 14 Russia 15 Spain 16 Sweden 17 Ukraine D F G H 1 J L M N o P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI Shots on t Shots off 1 Shooting Goals-to-s Total shot Hit Wood Penalty go Penalties Headed g Passes Passes cor Passing A Touches Crosses Dribbles Corners T Tackles Clearance Intercepti Clearance Clean She Blocks Goals con Saves mac Saves-to-s Fouls Wor Fouls Con Offsides Yellow Ca Red Cards Subs on Subs off Players Used 4 13 12 0.519 0.16 32 0 0 0 2 1076 828 0.769 1706 60 42 14 49 83 56 0 10 3 13 0.813 41 62 2 9 0 9 9 16 4 13 18 0.419 0.129 39 0 0 0 0 1565 1223 0.781 2358 46 68 21 62 98 37 2 1 10 6 9 0.601 53 73 8 7 0 11 11 19 4 10 10 0.5 0.2 27 1 0 0 3 1298 1082 0.833 1873 43 32 16 40 61 59 0 1 10 5 10 0.667 25 38 8 4 0 7 7 15 5 11 18 0.5 0.172 40 0 0 0 3 1488 1200 0.806 2440 58 60 16 86 106 72 1 2 29 3 22 0.881 43 45 6 5 0 11 11 16 3 22 24 0.379 0.065 65 1 0 0 0 2066 1803 0.872 2909 55 76 28 71 76 58 0 1 7 5 6 0.546 36 51 5 6 0 11 11 19 10 32 32 0.478 0.156 80 2 1 0 2 2774 2427 0.874 3761 101 60 35 91 73 69 0 1 11 6 10 0.626 63 49 12 4 0 15 15 17 5 8 18 0.307 0.192 32 1 1 1 0 1187 911 0.767 2016 52 53 10 65 123 87 0 1 23 7 13 0.651 67 48 12 9 1 12 12 20 6 34 45 0.43 0.075 110 2 0 0 2 3016 2531 0.839 4363 75 75 30 98 137 136 1 2 18 7 20 0.741 101 89 16 16 0 18 18 19 2 12 36 0.25 0.041 60 2 0 0 0 1556 1381 0.887 2163 50 49 22 34 41 41 0 0 9 5 12 0.706 35 30 3 5 0 7 7 15 2 15 23 0.394 0.052 48 0 0 0 1 1059 852 0.804 1724 55 39 14 67 87 62 0 8 3 6 0.667 48 56 3 7 1 7 7 17 6 22 42 0.343 0.093 82 6 6 0 0 2 1891 1461 0.772 2958 91 64 41 78 92 86 2 11 4 10 0.715 73 90 10 12 0 14 14 16 1 7 12 0.368 0.052 0 0 0 0 1 851 606 0.712 1433 43 18 8 45 78 43 0 23 9 17 0.654 43 51 11 6 1 10 17 5 9 31 0.225 0.125 59 2 0 0 1 1602 1345 0.839 2278 40 40 21 65 74 58 0 8 3 10 0.77 34 43 4 6 0 7 7 7 16 12 42 33 0.559 0.16 100 0 1 0 2 4317 3820 0.884 5585 69 106 44 122 102 79 5 8 1 15 0.938 102 83 19 11 0 17 17 18 5 17 19 0.472 0.138 39 3 0 0 1 1192 965 0.809 1806 44 29 7 56 54 45 1 12 5 8 0.616 35 51 7 7 7 0 9 9 18 2 7 26 0.212 0.06 38 0 0 0 2 1276 1043 0.817 1894 33 26 18 65 97 29 0 4 4 13 0.765 48 31 4 5 0 9 9 18 28 10 OOHOOOO

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

PostgreSQL Up And Running A Practical Guide To The Advanced Open Source Database

Authors: Regina Obe, Leo Hsu

3rd Edition

1491963417, 978-1491963418

More Books

Students also viewed these Databases questions