Question 46What will be output for the following code?import pandas as pddf = = pd.read_csv('data.csv')new_df = df [['Duration','Pulse', 'Calories']][df.Maxpulse==df['Maxpulse'].max()]print (new_df)Data in data.csv01234Duration Pulse Maxpulse Calories60 110130 409.160117145479.060103340.045109282.445117406.031353175148Duration Pulse Maxpulse Calories45 109282.4175001234Duration45Duration60Duration6060604545Pulse109CaloriesPulse110Pulse110117103109117282.4Calories409.1Calories409.1479.0340.0282.4406.0

A Pandas DataFrame can be created by loading the datasets from existing storage, storage can be SQL…

Answered: What will be output for the following…

What will be output for the following code? import pandas as pd df = pd.read_csv('data.csv') new_df = df [['Duration','Pulse', 'Calories']][df.Maxpulse==df['Maxpulse'].max()] print (new_df)

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

See similar textbooks

Similar questions

Consider the following line of code: int[] somearray = new int[30]; Which one of the following options is a valid line of code for displaying the twenty-eighth element of somearray?
(This is for devc++ version 5.11) Create a text file with following data to test your code. Please use array of structure and try to use functions and pass array of structures to functions. Read the following data from this text file: Johnson 85 83 77 91 76Aniston 80 90 95 93 48Cooper 78 81 11 90 73Gupta 92 83 30 69 87Blair 23 45 96 38 59Clark 60 85 45 39 67Kennedy 77 31 52 74 83Bronson 93 94 89 77 97Sunny 79 85 28 93 82Smith 85 72 49 75 63 LOOK AT PICTURES
I have the following code but it is not running correctly! import csvlst = []def save_dict_to_csv(storage, file_name): with open(file_name, 'w', newline = '') as f: f.write(file_name) f.write('\n') for key, value in storage.items(): lst1 = [] lst1.append(str(key)) for val in value : if type(val) == list: for v in val: lst1.append(str(v)) else: lst1.append(str(val)) for i in range(len(lst1)): if i != (len(lst1) - 1): f.writelines(lst1[i] + ',') else: f.writelines(lst1[i]) f.writelines('\n') f = open(file_name) print(f.read()) if __name__ == "__main__": storage = { 101: ["quiz", 12, [1,2,3,4]], 102: ["final", 53, [10, 10, 10, 10]] } res = save_dict_to_csv(storage,…
Write down a code whose file name is the initials of your name and sumame, which generates a row vector named x in the inclusive range between 2 and 2 with the number of elements which is equal to the sum of the digits in your student number using the bult-in function generating linearly spaced vector. Next your code includes another row vector named y as follows sin(x)
JUST ONLY USE <iostream>. Not use class, not use switch case. Write a program that reads 10 pairs of Cartesian coordinates from a file called "points.txt" and sorts them by increasing x-values, decreasing y-values, and increasing distance from the origin. Use only one sorting routine. Use an enumerated data type to keep track of the field on which the list is being sorted. The number of pairs should be in a global constant c++
Which of the following code segments will use vectorisation to reduce the time taken to calculate the sum of two NumPy arrays: A and B? (Select ALL that apply) 1. ) C = np.empty(A.size) for index in range(A.size): C[index] = A[index] + B[index] 2.) A.tolist()+B.tolist() 3.) np.sum([A, B]) 4.) A+B
This code gets an error for going out of range in the last for loop. What can I do to fix this? # Lucas Conklin# 5772707import csvimport statistics def readCSVIntoDictionary(f_name): data = [] with open(f_name) as f: reader = csv.reader(f) for row in reader: if not data: for index in range(len(row)): data.append([]) for index in range(len(row)): data[index].append(float(row[index])) f.close() return data features = readCSVIntoDictionary("C:\\Users\\lucas\\Downloads\\pima.csv")print(features) def find_median_and_SD(data, feature): med = statistics.median(data[feature]) rounded_med = round(med, 4) st_dev = statistics.stdev(data[feature]) rounded_st_dev = round(st_dev, 5) return rounded_med, rounded_st_dev for i in range(0, len(features)): (median, st_dev) = find_median_and_SD(features, i) print(f'Feature {i} Median: {median} Standard Deviation: {st_dev}')…
Create a .txt file with 3 rows of various movies data of your choice in the following table format: Movie ID number of viewers rating release year Movie name 0000012211 174 8.4 2017 "Star Wars: The Last Jedi" 0000122110 369 7.9 2017 "Thor: Ragnarok" Create a class Movie which instantiates variables corresponds to the table columns. Implement getters, setters, constructors and toString. ----Important 1. Implement two search methods to search Movies by their rating from unsorted array and by year (first) and a rating (second) from unsorted List. Test your methods and explain their time complexity.
use code below in part with bts #include <stdio.h>#include <stdlib.h>#include <time.h> typedef struct node_struct {int item;struct node_struct *next;} node; /*** 10->NULL* We want to insert 20* First call ([10], 20) [not complete]* {10, {20, NULL}} To compute the conditional probabilities you need to determine unigram andbigram counts first (you can do this in a single pass through a file if you do thingscarefully) and store them in a Binary Search Tree (BST). After that, you can computethe conditional probabilities.Input filesTest files can be found on (http://www.gutenberg.org/ebooks/). For example,search for “Mark Twain.” Then click on any of his books. Next download the “PlainText UTF-8” format.In addition, you should test your program on other input files as well, for which youcan hand-compute the correct answer.Output filesYour program must accept the name of an input file as a command line argument.Let's call the file name of this file fn. Your program must…
Write a statement that declares a jagged array of int values and initialize the columns of each row with the values in the following table of data: 2 4 6 3 5 7 9 5 9 11 17 21
In Dist.txt it will add vaccine in storage like how many vaccines are needed and from where is coming and Add search function in which from user it will check how many vaccines are available in storage this will be done in Vaccine.txt somewhat like in image given #include <stdio.h>#include <stdlib.h>#include <string.h> struct vacc{ char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float population; }v[10]; // Function Declarations void create_inventory(); void update_vacc_qty(); int search_vaccine(); void display_vaccine(); // Main Function starts here int main() { //create_inventory(); //display_vaccine(); //search_vaccine(); update_vacc_qty(); return 0; } //Function to Create Vaccine.txt as per the given table void create_inventory() { int option = 1; // variables to collect data as per table given char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float populaion; //File definition FILE *infile; infile = fopen("Vaccine.txt","w");…
Integer dataSize is read from input. Then, strings and integers are read and stored into string vector subjectList and integer vector pageList, respectively. Lastly, integer pageThreshold is read from input. Set matchCount with the number of element pairs with a page greater than or equal to pageThreshold. Output the subject of each pair found with a page greater than or equal to pageThreshold. End with a newline. Ex: If the input is: 3 Environment 416 Cooking 353 Science 306 349 Then the output is: Environment Cooking Total: 2 By using the following code: #include #include using namespace std; int main() { int numElements; int pageThreshold; int matchCount; unsigned int i; cin >> numElements; vector subjectList(numElements); vector pageList(numElements); for (i = 0; i < subjectList.size(); ++i) { cin >> subjectList.at(i); cin >> pageList.at(i); } cin >> pageThreshold; /* Your code goes here */ cout << "Total: " << matchCount;…