Table 1 shows the data of class A students in University XYZ. The data file name is class- a.csv. The data consist of information on gender, height, and weight for every student. Table 1: class-a.csv Student ID Name Gender Height Weight 23345 Ahmad Abu Male 1.68 84 23356 Siti Haliza Karim Female 1.57 66 23311 Nurul Arifin Female 1.63 45 23344 Mohd Ahmad Male 1.75 87 23317 Hassan Ismail Male 1.71 72 a) Write a python program that reads the data file class-a.csv into a data frame and displays 3 rows of those data, Please import the suitable library.

Table 1 shows the data of class A students in University XYZ. The data file name is class- a.csv. The data consist of information on gender, height, and weight for every student. Table 1: class-a.csv Student ID Name Gender Height Weight 23345 Ahmad Abu Male 1.68 84 23356 Siti Haliza Karim Female 1.57 66 23311 Nurul Arifin Female 1.63 45 23344 Mohd Ahmad Male 1.75 87 23317 Hassan Ismail Male 1.71 72 a) Write a python program that reads the data file class-a.csv into a data frame and displays 3 rows of those data, Please import the suitable library.

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 1GZ

See similar textbooks

Similar questions

Use the data file “marketing_campaign.csv” for this problem. Note: There are rows at the top of the file that must be skipped. a. Read the data into R and create a subset consisting of the following columns: Education, Marital_Status, Income, Dt_Customer, MntFruits, and Complain. b. Convert the data a type of the following columns: Education Ordered factor (Hint: Level of “2n Cycle” is between Graduation and Master Marital_Status Unordered factor Income Double precision numeric Complain Logical c. Convert the data type of Dt_Customer to Date. d. With proper code check the data types of columns are as stated in (b) and (c).
Answer the given question with a proper explanation and step-by-step solution. For this question use the file data1.csv The file contains information on various customers. Each customer has a unique customer id. The data also has information on age income and Gender of the customers. Space can be used as a delimiter for this file. Find the following: A) The total number of the rows in the file. B) The number of unique customer ids in the datafile. For this question create a set object which will only allow you to add unique customer ids. C) The program asks user to provide an id and prints information about that customer. Make sure to take care for the errors due to invalid id (i.e., id does not present in data). Print “id not found” when id is not found. Save the file as Solution1.java. You can use either File Reader or Scanner classes to read the data in the csv file. Your program should print the following after filling the blanks with the appropriate values Outcome: The total…
The file LaptopSalesJanuary2008.csv contains data for all sales of laptops at a computer chain in London in January 2008. This is a subset of the full dataset that includes data for the entire year. I. Create a bar chart, showing the average retail price by store. Which store has the highest average? Which has the lowest? Please give proper explanation and typed answer only.
get_total_cases() takes the a 2D-list (similar to database) and an integer x from this set {0, 1, 2} as input parameters. Here, 0 represents Case_Reported_Date, 1 represents Age_Group and 2 represents Client_Gender (these are the fields on the header row, the integer value represents the index of each of these fields on that row). This function computes the total number of reported cases for each instance of x in the text file, and it stores this information in a dictionary in this form {an_instance_of_x : total_case}. Finally, it returns the dictionary and the total number of all reported cases saved in this dictionary.
orderdp.cpp: #include <fcntl.h> #include <stdlib.h> #include <unistd.h> #include <inttypes.h> #include "orders.h" item::item(uint16_t s, uint16_t q) : sku(s), quantity(q) { } item_list::item_list() : items(NULL), num_products(0) { } void item_list::add(const item& i) { items = (item**)realloc(items, (num_products+1)*sizeof(item*)); items[num_products] = new item(i); num_products++; } order::order(uint16_t o, std::string n) : order_id(o), customer_name(n) { } void order::addItem(const item& i) { product_items.add(i); } order** read_orders(const char* filename, uint16_t* num_orders) { int fd; fd = open(filename, O_RDONLY); int err = fd; if (err == -1) { return NULL; } read(fd, num_orders, sizeof(*num_orders)); order** orders = new order*[*num_orders]; for (int i=0; i<*num_orders; i++) { uint16_t order_id; uint16_t num_products; read(fd, &order_id,…
def read_cars(full_path_file_name):"""Read the data from csv file given full path file name (including directory)Return a list of Car instances:param full_path_name: csv file:return: list of instances of the Car class""" file: 2017,Subaru,WRX,268,32722000,Honda,Civic Si,160,26122020,Lamborghini,Aventador S,729,34722017,Subaru,WRX,268,32722000,Honda,Civic Si,160,26122020,Lamborghini,Aventador S,729,34722017,Subaru,WRX,268,32722000,Honda,Civic Si,160,26122020,Lamborghini,Aventador S,729,34722020,Lamborghini,Huracan,729,3472
USE supermarkett; CREATE TABLE product(product_id INT NOT NULL,product_name VARCHAR(45) NOT NULL,price FLOAT NOT NULL,prod_discount INT NOT NULL,product_type VARCHAR(45) NOT NULL,PRIMARY KEY (product_id)); CREATE TABLE stock (stock_id INT NOT NULL,product_id INT NOT NULL,quantity INT NOT NULL,product_status BOOLEAN NOT NULL,PRIMARY KEY (stock_id),FOREIGN KEY (product_id) REFERENCES product(product_id));CREATE TABLE employee (emp_id INT NOT NULL,emp_name VARCHAR(45) NOT NULL,emp_number INT NOT NULL,address VARCHAR(45) NOT NULL,PRIMARY KEY (emp_id));CREATE TABLE supplier (sup_id INT NOT NULL,sup_name VARCHAR(45) NOT NULL,sup_number INT NOT NULL,address VARCHAR(45) NOT NULL,PRIMARY KEY (sup_id));CREATE TABLE login (login_id INT NOT NULL,password VARCHAR(45) NOT NULL,PRIMARY KEY (login_id)); ALTER TABLE stockADD FOREIGN KEY (product_id) REFERENCES product(product_id); ------------------------------------------------------------------------------- make 2 different -stored procedure- query…
Use the sacramento.csv file to complete the following assignment. Create a file, sacramento.py, that loads the .csv file and runs a logistic regression. The regression should predict whether or not a house has 1 or more than one bathroom based on beds, sqft, and price, in that order. Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it. You will need to create a new variable from baths, and it should make it such that those observations of 1 bath correspond to a value of 0, and those with more than 1 bath correspond to a 1. Make sure to add a constant using sm.add_constant(X) Your file should print the results in this way: print(mod.params.round(2)) print(mod.pvalues.round(2)) print('The smallest p-value is for sqft')
V5. min jee wants to combine the sales data from each of the art fairs. switch to the combined sales worksheet and then update the worksheet as follows. in cell A5 enter a formula without using a function that references cell a5 in the Madison worksheet. copy the formula from cell a5 to the range a6:a8 without copying the formatting. in cell b5, enter a formula using the sum function, 3d references, grouped worksheets that totals the values from cell b:5 in the chicago: madison worksheets.
you are required to read input file containing data of countries or region, to compute and display the data in decreasing order, and some statistics in an output file. Structure of input file: The first two lines of input files contains the region information, date of taken data, and heading of the records. Each line of the rest in the input file contains country name, confirmed and death total cases. COVID_19_data class: used to store records from input file. You should provide generic methods to compute average of confirmed cases, to sort list in descending order using selection sortii , and any additional method(s) to solve the problem. Tester Class: your main method should class two methods to read the data and to display the result as shown below. Your class should be user friendly and control any unchecked errors
You are contracted to complete the data system for Citywide Taxi Company. Now, the information for each taxi is expanded to include: taxi id (such as CTC0001), the driver’s name, the maker of the Car (such as Ford), the model of the car (such as Escape), the Color of the Car (such as Black), the license number (such as HXT 4578), the number of passages the car served in the entire shift (integer type, this field will be left empty for this project). Your C++ program will (with array of class object): Define a class for the car with all members of variable mentioned above as private; Write all necessary class member functions to access those member variables (write or read); Read up to 50 records of data from the keyboard (provide a method to end the input before reaching 50 records) Save all records inputted from step 3 to a disk file called CTC.dat.
. Load the data into a pandas dataframe named data_firstname_df2 where first name is you name.2. Replace the ‘?’ mark in the ‘bare’ column by np.nan and change the type to ‘float’3. Drop the ID column4. Separate the features from the class.5. Split your data into train 80% train and 20% test use the last two digits of your student number for the seed. 6. Using the preprocessing library to define two transformer objects to transform your training data:a. Fill the missing values with the median (hint: checkout SimpleImputer)b. Scale the data (hint: checkout StandardScaler)7. Combine the two transformers into a pipeline name it num_pipe_firstname.8. Create a new Pipeline that has two steps the first is the num_pipe_firstname and the second is an SVM classifier with random state = last two digits of your student number. Name the pipelinepipe_svm_firstname. (make note of the labels)9. Take a screenshot showing your num_pipe_firstname object and add it to your written report.10. Define the…