Question: Solve using PYTHON Write a script that reads a file cars.csv, into a pandas structure and then print Get the first column and the second

Solve using PYTHON

Write a script that reads a file cars.csv, into a pandas structure and then print Get the first column and the second to last column from cars.csv

Perform following operations on these two vectors and print the result

addition and subtraction.convert a pandas dataframe to a numpy array element-wise multiplication

inner product

three norms

compute the distance between these two vectors

2) Get the first three columns and the last three columns from cars.csv

addition and subtraction

compute the transpose of the second matrix: C = B^T, and print the shape of C

compute the product between A and C, and print the result and its shape

compute the transpose of the first matrix: D = A^T, and print the shape of D

compute the product between D and B, and print the result and its shape

car.csv file

Car,MPG,Cylinders,Displacement,Horsepower,Weight,Acceleration,Model,Origin Chevrolet Chevelle Malibu,18,8,307,130,3504,12,70,US Buick Skylark 320,15,8,350,165,3693,11.5,70,US Plymouth Satellite,18,8,318,150,3436,11,70,US AMC Rebel SST,16,8,304,150,3433,12,70,US Ford Torino,17,8,302,140,3449,10.5,70,US Ford Galaxie 500,15,8,429,198,4341,10,70,US Chevrolet Impala,14,8,454,220,4354,9,70,US Plymouth Fury iii,14,8,440,215,4312,8.5,70,US Pontiac Catalina,14,8,455,225,4425,10,70,US AMC Ambassador DPL,15,8,390,190,3850,8.5,70,US Citroen DS-21 Pallas,0,4,133,115,3090,17.5,70,Europe Chevrolet Chevelle Concours (sw),0,8,350,165,4142,11.5,70,US Ford Torino (sw),0,8,351,153,4034,11,70,US Plymouth Satellite (sw),0,8,383,175,4166,10.5,70,US AMC Rebel SST (sw),0,8,360,175,3850,11,70,US Dodge Challenger SE,15,8,383,170,3563,10,70,US Plymouth 'Cuda 340,14,8,340,160,3609,8,70,US Ford Mustang Boss 302,0,8,302,140,3353,8,70,US Chevrolet Monte Carlo,15,8,400,150,3761,9.5,70,US Buick Estate Wagon (sw),14,8,455,225,3086,10,70,US Toyota Corolla Mark ii,24,4,113,95,2372,15,70,Japan Plymouth Duster,22,6,198,95,2833,15.5,70,US AMC Hornet,18,6,199,97,2774,15.5,70,US Ford Maverick,21,6,200,85,2587,16,70,US Datsun PL510,27,4,97,88,2130,14.5,70,Japan Volkswagen 1131 Deluxe Sedan,26,4,97,46,1835,20.5,70,Europe Peugeot 504,25,4,110,87,2672,17.5,70,Europe Audi 100 LS,24,4,107,90,2430,14.5,70,Europe Saab 99e,25,4,104,95,2375,17.5,70,Europe BMW 2002,26,4,121,113,2234,12.5,70,Europe AMC Gremlin,21,6,199,90,2648,15,70,US Ford F250,10,8,360,215,4615,14,70,US Chevy C20,10,8,307,200,4376,15,70,US Dodge D200,11,8,318,210,4382,13.5,70,US

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using python write a script reads a file .csv file , into a pandas structure and then print the first 2 rows and the last 2 of the dataset the 2 with the lowest average-mileage the 2 with the highest...

Matlab Assignment This assignment is to make a tool to enhance images. It should reduce red-eye, allow the user to gray-out part of the image, and allow the user to blur part of the image. Allow the...

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

please help in python. read cars.csv and do these step cars.csv file. X is cars.csv Car,MPG,Cylinders,Displacement,Horsepower,Weight,Acceleration,Model,Origin Chevrolet Chevelle...

Python and most Python libraries are free to download or use, though many users use Python through a paid service. Paid services help IT organizations manage the risks associated with the use of...

I need help with Python. These are the functions created in a script. I don't need help with the functions. I need help with the problems that are done after the functions are created. I created the...

Please make sure it is working. You can use any image as long as the outcome is the same. ECE 72 (50pts) Project 1: Digital Image Processing The file Parkes.png is available on Canvas. This file...

***data.csv*** **lin_reg.py** import numpy as np import pandas as pd import matplotlib.pyplot as plt # function name: least_sq # inputs: file_name- name of the csv file # output: m(slope),...

- DO NOT SEND CODE THAT HAS ALREADY BEEN POSTED ON CHEGG. THOSE ANSWERS DON'T WORK - DO NOT HAVE COMMENTS IN THE CODE - WRITE CODE IN JAVA Objectives This is one of two major programming projects...

Winslow Inc., a manufacturing firm, manufactures tires. The company has supplied information from its accounting records for the last year. Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec No....

Based on the data in Exercise 4-34, prepare the adjusting entries for Zeidman Security Services Co. In exercise Zeidman Security Services Co. offers security services to business clients. The...

If USD/JPY was 106.02 six months ago and is now 110.40 today, how much has the dollar appreciated or depreciated? Question 12Select one: a. appreciated; about 3.97% b. appreciated; about 4.10% c....

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

After Column and Data Types have been set in the Mining Structure, what is the next step?

What needs to occur after any Structural or Variable setting change in SSAS Mining Structures?

For the highest GS Pay Grade Group (1115) in the Federal Government, what are the chances of Females being included? Do Females have longer service statistics in that Group?