
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Use Python Code
how to filter dataframes using python . For example I have a student grade csv table, first, I need to read the csv using pandas library then I want to visualize my student scores (using matplotlib, seaborn, etc) but I only want to visualize those whose scores are 60 and above. so how do i do the code in python.
Exampe of Student grades table (csv)(Student name and exam date):
Student name | 4/7/20 |
Jojo | 90 |
Lili | 65 |
Bibi | 50 |
Sarah | 40 |
Rajah | 100 |
Albert | 80 |
Cherry | 75 |
Jamie | 85 |
So , based on the table above, what doesn't need to be visualized is Bibi and Sarah .
Hope you can help me :)
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps with 1 images

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.Similar questions
- Write a program to reduce the number of gray levels L in a PGM image from L=256 to: (i) L=128,(ii) L=32, (iii) L=8, and (iv) L=2. Show your results using the “lenna” and “peppers” images. Forcomparison purposes, subsample the gray-levels to better visualize the quantized images (e.g.,if L=128, you can use 0, 2, 4, …, 254 with Q=255 in the PGM file instead of 0, 1, 2, …, 127 withQ=127; similarly, if L=2, you can use 0, 127 with Q=255 instead of 0, 1 with Q=1).arrow_forwardThe following 4 line data source will be input to a wordcount mapreduce implementation having 3 mappers and 2 reducers;FIRST NAME LAST NAME COMP NAMEPHONE PHONE EMAIL WEBJOHN BUTT BENTON JOHNHTTP WWW BENTON COMThe data will be split into individual lines with each line processed by one of the mappers.Using the 1st line from the data source, show the output produced by the mapper that processes that linearrow_forwardSay we are about to build an ArrayList. Your ArrayList should guarantee that the array capacity is at most four times the number of elements. What would you like to do to maintain such a limit on the capacity? What is the benefit of using iterators? Can you describe your first experience of GUIs? And could you describe what is the advantage of using GUIs over Command-Line Interface (CLI) operations?arrow_forward
- For items 1–3, use the IN300_Dataset1.csv file. Write a Python program that reads the CSV file into a Panda dataframe. Using that dataframe, print the row, source IP, and destination IP as a table. Write a Java program that reads the CSV file into an ArrayList. Convert the ArrayList to a string array and print the row, source IP, and destination IP on the same line using a loop. Write an R program that reads the CVS file using the read.csv data type. Print the row, source IP and destination IP of each line.arrow_forwardImplement a city database using ordered lists. Each database record contains the name of the city (a string of arbitrary length) and the coordinates of the city expressed as integer x and y coordinates. Your database should allow records to be inserted, deleted by name, and searched by name. Another operation that should be supported is to print all records within a given distance of a specified point/coordinate. The order of cities should be alphabetically by city name. Implement the database using: an array- based list implementation. By using JAVA.arrow_forwardGive an example of something you can use a page-word index for that you can't do with a page index (no word positions), such as the one below. Word Index a 2, 3 according 2 and 2 be 2 blue 3 … (please type answer not write by hend)arrow_forward
- Use Python Codehow to filter dataframes using python . For example I have a student grade csv table, first, I need to read the csv using pandas library then I want to visualize my student scores (using matplotlib, seaborn, etc) but I only want to visualize those whose scores are 60 and above. so how do i do the code in python.Exampe of Student grades table (csv) : Student name Score Jojo 90 Lili 65 Bibi 50 Sarah 40 Rajah 100 Albert 80 Cherry 75 Jamie 85 So , based on the table above, what doesn't need to be visualized is Bibi and Sarah . Hope you can help me :)arrow_forwardFinal help needed for Python Turtle, does my code have everything required, and if not can you help make the changes needed. 1. An additional option to generate another island if the user does not like the one they have (loops until they are satisfied) and have the GUIs bigger.2. Does my code have two or more functions (I dont know if the drawing only counts as one)?3. Does my code have atleast one list, dictionary, or set (if not reorganize/add one)?4. Need help exporting the finished turtle image into a file on desktop (yes/no option input by user) that can be accessed, or png (In ###'s I saved the broken code that i dont know how to fix) My code: import turtleimport randomimport tkinter as tkfrom tkinter import simpledialog### OPTIONAL IMAGE CONVERTER, REMOVE ###'S TO USE###from PIL import Image# Colors:ocean = "#000066"sand = "#ffff66"grass = "#00cc00"lake = "#000066"mountain_color = "#808080" mountain_positions = []def draw_irregular_circle(radius, line_color, fill_color,…arrow_forwardA grid needs a system for numbering the tiles in order to allow random-access lookup.For instance, the rows and columns of a square grid provide a natural numbering for the tiles. Create plans for hexagonal and triangular grids. Create a rule for identifying the neighbourhood (i.e., nearby tiles) of a certain tile in the grid using the numbering scheme. For instance, the neighbourhood of tile I j in a four-connected square grid with indices of I for rows and j for columns may be described as neighbourhood(i, j) = I 1, j, I j 1.arrow_forward
- Create a square matrix that has ones in the first row and first column, and whose remaining elements are the sum of two elements: the element above and the element to the left. Your program should be able to make a matrix of any size. Do this exercise using a loop (for or while) with break/continue statements as necessary.arrow_forwardTask 4: Matplotlib Import the plotting function by the command: import matplotlib.pyplot as plt Plotting multiple lines Compute the x and y coordinates for points on sine and cosine curves and plot them on the same graph using matplotlib. Add x and y labels to the graph as well. Note: Please provide PYTHON (ANACONDA) code for above task.arrow_forwardWrite a small piece of pseudo-code for generating a histogram H[L] for an intensity image I[YDIM][XDIM], where L is the total level of intensities of the image, H is the histogram array, XDIM * YDIM are the size of the image, and I[i][j] is the intensity value of the pixel at location (i,j), with i = 1, …, YDIM, and j = 1,…, XDIM. You might choose to use a certain program language that you are familiar with to write the code. You don’t have to compile the code.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

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)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education