In PYTHON Print values from the Goal column only Print values only for columns: Team, Yellow Cards and Red Cards Find and print rows for teams that scored more than 6 goals Select the teams whose name start with a G Print values only for columns Team and Shooting Accuracy , and only for rows in which the team is either of the following: England, Italy and Spain Find and print rows for teams that scored more than 6 goals and at least 4000 passes Team Goals Shots on target Shots off target Shooting Accuracy Goals-to-shots (perc) Total shots (inc. Blocked) Hit Woodwork Penalty goals Penalties not scored Headed goals Passes Passes completed Passing Accuracy Touches Crosses Dribbles Corners Taken Tackles Clearances Interceptions Clearances off line Clean Sheets Blocks Goals conceded Saves made Saves-to-shots ratio Fouls Won Fouls Conceded Offsides Yellow Cards Red Cards Subs on Subs off Players Used Croatia 4 13 12 0.5 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 Czech Republic 4 13 18 0.4 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 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.667 25 38 8 4 0 7 7 15 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.881 43 45 6 5 0 11 11 16 France 3 22 24 0.4 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 Germany 10 32 32 0.5 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 Greece 5 8 18 0.3 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 Italy 6 34 45 0.4 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 Netherlands 2 12 36 0.3 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 Poland 2 15 23 0.4 0.052 48 0 0 0 1 1059 852 0.804 1724 55 39 14 67 87 62 0 0 8 3 6 0.667 48 56 3 7 1 7 7 17 Portugal 6 22 42 0.3 0.093 82 6 0 0 2 1891 1461 0.772 2958 91 64 41 78 92 86 0 2 11 4 10 0.715 73 90 10 12 0 14 14 16 Republic of Ireland 1 7 12 0.4 0.052 28 0 0 0 1 851 606 0.712 1433 43 18 8 45 78 43 1 0 23 9 17 0.654 43 51 11 6 1 10 10 17 Russia 5 9 31 0.2 0.125 59 2 0 0 1 1602 1345 0.839 2278 40 40 21 65 74 58 0 0 8 3 10 0.77 34 43 4 6 0 7 7 16 Spain 12 42 33 0.6 0.16 100 0 1 0 2 4317 3820 0.884 5585 69 106 44 122 102 79 0 5 8 1 15 0.938 102 83 19 11 0 17 17 18 Sweden 5 17 19 0.5 0.138 39 3 0 0 1 1192 965 0.809 1806 44 29 7 56 54 45 0 1 12 5 8 0.616 35 51 7 7 0 9 9 18 Ukraine 2 7 26 0.2 0.06 38 0 0 0 2 1276 1043
In PYTHON Print values from the Goal column only Print values only for columns: Team, Yellow Cards and Red Cards Find and print rows for teams that scored more than 6 goals Select the teams whose name start with a G Print values only for columns Team and Shooting Accuracy , and only for rows in which the team is either of the following: England, Italy and Spain Find and print rows for teams that scored more than 6 goals and at least 4000 passes Team Goals Shots on target Shots off target Shooting Accuracy Goals-to-shots (perc) Total shots (inc. Blocked) Hit Woodwork Penalty goals Penalties not scored Headed goals Passes Passes completed Passing Accuracy Touches Crosses Dribbles Corners Taken Tackles Clearances Interceptions Clearances off line Clean Sheets Blocks Goals conceded Saves made Saves-to-shots ratio Fouls Won Fouls Conceded Offsides Yellow Cards Red Cards Subs on Subs off Players Used Croatia 4 13 12 0.5 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 Czech Republic 4 13 18 0.4 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 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.667 25 38 8 4 0 7 7 15 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.881 43 45 6 5 0 11 11 16 France 3 22 24 0.4 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 Germany 10 32 32 0.5 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 Greece 5 8 18 0.3 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 Italy 6 34 45 0.4 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 Netherlands 2 12 36 0.3 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 Poland 2 15 23 0.4 0.052 48 0 0 0 1 1059 852 0.804 1724 55 39 14 67 87 62 0 0 8 3 6 0.667 48 56 3 7 1 7 7 17 Portugal 6 22 42 0.3 0.093 82 6 0 0 2 1891 1461 0.772 2958 91 64 41 78 92 86 0 2 11 4 10 0.715 73 90 10 12 0 14 14 16 Republic of Ireland 1 7 12 0.4 0.052 28 0 0 0 1 851 606 0.712 1433 43 18 8 45 78 43 1 0 23 9 17 0.654 43 51 11 6 1 10 10 17 Russia 5 9 31 0.2 0.125 59 2 0 0 1 1602 1345 0.839 2278 40 40 21 65 74 58 0 0 8 3 10 0.77 34 43 4 6 0 7 7 16 Spain 12 42 33 0.6 0.16 100 0 1 0 2 4317 3820 0.884 5585 69 106 44 122 102 79 0 5 8 1 15 0.938 102 83 19 11 0 17 17 18 Sweden 5 17 19 0.5 0.138 39 3 0 0 1 1192 965 0.809 1806 44 29 7 56 54 45 0 1 12 5 8 0.616 35 51 7 7 0 9 9 18 Ukraine 2 7 26 0.2 0.06 38 0 0 0 2 1276 1043
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
100%
In PYTHON
-
Print values from the Goal column only
-
Print values only for columns: Team, Yellow Cards and Red Cards
-
Find and print rows for teams that scored more than 6 goals
-
Select the teams whose name start with a G
-
Print values only for columns Team and Shooting Accuracy , and only for rows in which the team is either of the following: England, Italy and Spain
-
Find and print rows for teams that scored more than 6 goals and at least 4000 passes
Team | Goals | Shots on target | Shots off target | Shooting Accuracy | Goals-to-shots (perc) | Total shots (inc. Blocked) | Hit Woodwork | Penalty goals | Penalties not scored | Headed goals | Passes | Passes completed | Passing Accuracy | Touches | Crosses | Dribbles | Corners Taken | Tackles | Clearances | Interceptions | Clearances off line | Clean Sheets | Blocks | Goals conceded | Saves made | Saves-to-shots ratio | Fouls Won | Fouls Conceded | Offsides | Yellow Cards | Red Cards | Subs on | Subs off | Players Used | |
Croatia | 4 | 13 | 12 | 0.5 | 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 | ||
Czech Republic | 4 | 13 | 18 | 0.4 | 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 | |
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.667 | 25 | 38 | 8 | 4 | 0 | 7 | 7 | 15 | |
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.881 | 43 | 45 | 6 | 5 | 0 | 11 | 11 | 16 | |
France | 3 | 22 | 24 | 0.4 | 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 | |
Germany | 10 | 32 | 32 | 0.5 | 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 | |
Greece | 5 | 8 | 18 | 0.3 | 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 | |
Italy | 6 | 34 | 45 | 0.4 | 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 | |
Netherlands | 2 | 12 | 36 | 0.3 | 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 | |
Poland | 2 | 15 | 23 | 0.4 | 0.052 | 48 | 0 | 0 | 0 | 1 | 1059 | 852 | 0.804 | 1724 | 55 | 39 | 14 | 67 | 87 | 62 | 0 | 0 | 8 | 3 | 6 | 0.667 | 48 | 56 | 3 | 7 | 1 | 7 | 7 | 17 | |
Portugal | 6 | 22 | 42 | 0.3 | 0.093 | 82 | 6 | 0 | 0 | 2 | 1891 | 1461 | 0.772 | 2958 | 91 | 64 | 41 | 78 | 92 | 86 | 0 | 2 | 11 | 4 | 10 | 0.715 | 73 | 90 | 10 | 12 | 0 | 14 | 14 | 16 | |
Republic of Ireland | 1 | 7 | 12 | 0.4 | 0.052 | 28 | 0 | 0 | 0 | 1 | 851 | 606 | 0.712 | 1433 | 43 | 18 | 8 | 45 | 78 | 43 | 1 | 0 | 23 | 9 | 17 | 0.654 | 43 | 51 | 11 | 6 | 1 | 10 | 10 | 17 | |
Russia | 5 | 9 | 31 | 0.2 | 0.125 | 59 | 2 | 0 | 0 | 1 | 1602 | 1345 | 0.839 | 2278 | 40 | 40 | 21 | 65 | 74 | 58 | 0 | 0 | 8 | 3 | 10 | 0.77 | 34 | 43 | 4 | 6 | 0 | 7 | 7 | 16 | |
Spain | 12 | 42 | 33 | 0.6 | 0.16 | 100 | 0 | 1 | 0 | 2 | 4317 | 3820 | 0.884 | 5585 | 69 | 106 | 44 | 122 | 102 | 79 | 0 | 5 | 8 | 1 | 15 | 0.938 | 102 | 83 | 19 | 11 | 0 | 17 | 17 | 18 | |
Sweden | 5 | 17 | 19 | 0.5 | 0.138 | 39 | 3 | 0 | 0 | 1 | 1192 | 965 | 0.809 | 1806 | 44 | 29 | 7 | 56 | 54 | 45 | 0 | 1 | 12 | 5 | 8 | 0.616 | 35 | 51 | 7 | 7 | 0 | 9 | 9 | 18 | |
Ukraine | 2 | 7 | 26 | 0.2 | 0.06 | 38 | 0 | 0 | 0 | 2 | 1276 | 1043 | 0.817 | 1894 | 33 | 26 | 18 | 65 | 97 | 29 | 0 | 0 | 4 | 4 | 13 | 0.765 | 48 | 31 | 4 | 5 | 0 | 9 | 9 | 18 |
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education