Could you help to check the error? Because when i run the code, it tells me :ValueError: could not convert string $\text{'}2023-01-01\text{'}$ to float$64$ the data type isDate,Location,Max Temperature $($C$),$Min Temperature $($C$),$Precipitation $($mm$),$Wind Speed $($km$/$h$),$Humidity $(\%),$Cloud Cover $(\%)$

$2023-01-01,$New York,$5,-2,10,20,70,40$

$2023-01-02,$New York,$4,-3,8,18,75,30$

$2023-01-03,$New York,$8,1,5,15,65,20$

$2023-01-04,$New York,$7,0,3,12,80,45$

$2023-01-05,$New York,$6,-1,2,10,85,50$

$2023-01-06,$New York,$3,-4,12,22,78,35$

$2023-01-07,$New York,$2,-5,15,25,82,30$

$2023-01-08,$New York,$1,-6,10,18,88,40$

$2023-01-09,$New York,$4,-3,8,20,85,38$

$2023-01-10,$New York,$6,0,5,15,75,42$

$2023-01-11,$New York,$7,1,2,14,70,38$

$2023-01-12,$New York,$5,-2,4,18,72,36$

$2023-01-13,$New York,$3,-4,6,16,78,40$

$2023-01-14,$New York,$2,-5,8,20,80,45$

$2023-01-15,$New York,$4,-3,10,22,75,35$

$2023-01-16,$New York,$6,0,12,18,68,30$

$2023-01-17,$New York,$7,1,15,15,62,28$

$2023-01-18,$New York,$5,-2,10,20,70,40$

$2023-01-19,$New York,$4,-3,8,18,75,30$

$2023-01-20,$New York,$8,1,5,15,65,20$

$2023-01-21,$New York,$7,0,3,12,80,45$

$2023-01-22,$New York,$6,-1,2,10,85,50$

$2023-01-23,$New York,$3,-4,12,22,78,35$

$2023-01-24,$New York,$2,-5,15,25,82,30,$ so I don't know how to duw with it to filter by city. My current code is #Group Project

#Task $1$

import numpy as np

data $=$ np$.$loadtxt$(\text{'}$data$\_$temperature.txt$\text{'},$ delimiter$=\text{'},\text{'},$ usecols$=[0,1,2,3,4,5,6,7],$ skiprows$=1)$

#Task $2$

def filter$\_$by$\_$city$($data$,$ city$\_$name$)$:

return data$[$data$[$:$,1]==$ city$\_$name.encode$()]$

New$\_$York$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'New York'$)$

Los$\_$Angeles$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'Los Angeles'$)$

London$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'London'$)$

Tokyo$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'Tokyo'$)$

Beijing$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'Beijing'$)$

Sydney$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'Sydney'$)$

Paris$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'Paris'$)$

Berlin$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'Berlin'$)$

Cairo$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'Cairo'$)$

New$\_$Delhi$\_$data $=$ filter$\_$by$\_$city$($data$,$ 'New Delhi'$)$

def calculate$\_$average$($city$\_$data$)$:

max$\_$temps $=$ city$\_$data$[$:$,2].$astype$($float$)$

min$\_$temps $=$ city$\_$data$[$:$,3].$astype$($float$)$

average$\_$temp $=($max$\_$temps $+$ min$\_$temps$)/2$

return average$\_$temp.mean$()$

#New$\_$York

print$($calculate$\_$average$($New$\_$York$\_$data$))$

#Los$\_$Angeles

print$($calculate$\_$average$($Los$\_$Angeles$\_$data$))$

#London

print$($calculate$\_$average$($London$\_$data$))$

#Tokyo

print$($calculate$\_$average$($Tokyo$\_$data$))$

#Beijing

print$($calculate$\_$average$($Beijing$\_$data$))$

#Sydney

print$($calculate$\_$average$($Sydney$\_$data$))$

#Paris

print$($calculate$\_$average$($Paris$\_$data$))$

#Berlin

print$($calculate$\_$average$($Berlin$\_$data$))$

#Cairo

print$($calculate$\_$average$($Cairo$\_$data$))$

#New$\_$Delhi

print$($calculate$\_$average$($New$\_$Delhi$\_$data$))$

#Total$\_$Precipitation

def total$\_$precipitation$($city$\_$data$)$:

total$\_$precipitation $=$ city$\_$data$[$:$,4].$astype$($float$).$sum$()$

return total$\_$precipitation

#New$\_$York

print$($total$\_$precipitation$($New$\_$York$\_$data$))$

#Los$\_$Angeles

print$($total$\_$precipitation$($Los$\_$Angeles$\_$data$))$

#London

print$($total$\_$precipitation$($London$\_$data$))$

#Tokyo

print$($total$\_$precipitation$($Tokyo$\_$data$))$

#Beijing

print$($total$\_$precipitation$($Beijing$\_$data$))$

#Sydney

print$($total$\_$precipitation$($Sydney$\_$data$))$

#Paris

print$($total$\_$precipitation$($Paris$\_$data$))$

#Berlin

print$($total$\_$precipitation$($Berlin$\_$data$))$

#Cairo

print$($total$\_$precipitation$($Cairo$\_$data$))$

#New$\_$Delhi

print$($total$\_$precipitation$($New$\_$Delhi$\_$data$))$

#Wind Speed

def max$\_$wind$\_$speed$($city$\_$data$)$:

return city$\_$data$[$:$,5].$astype$($float$).$max$()$

def min$\_$wind$\_$speed$($city$\_$data$)$:

return city$\_$data$[$:$,5].$astype$($float$).$min$()$

#New$\_$York

print$($max$\_$wind$\_$speed$($New$\_$York$\_$data$))$

print$($min$\_$wind$\_$speed$($New$\_$York$\_$data$))$

#Los$\_$Angeles

print$($max$\_$wind$\_$speed$($Los$\_$Angeles$\_$data$))$

print$($min$\_$wind$\_$speed$($Los$\_$Angeles$\_$data$))$

#London

print$($max$\_$wind$\_$speed$($London$\_$data$))$

print$($min$\_$wind$\_$speed$($Tokyo$\_$data$))$

#Beijing

print$($max$\_$wind$\_$speed$($Beijing$\_$data$))$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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!

Q:

JAVA Help I am getting this error when trying to run the code below, I need to know if i need anything more then what i have to run this: import java.util.Scanner; public class AutoLinkedinJobs {...

Q:

hi i need help im new to java im trying to run this code it show up the gui form but when im trying to search a car from my database it shows car not found this my code ; public class AddCarFormJava...

Q:

hi i need help im new to java im trying to run this code it show up the gui form but when im trying to search a car it shows car not found this my code ; public class AddCarFormJava extends JFrame {...

Q:

hi i need help im new to java im trying to run my code that will show the output of my sort price button and search button from eclipse that save to my database table vehicle but it will show car not...

Q:

I have posted this several times and my question has not been answered D: I'm hoping I can get some help. This is the homework prompt if needed for reference: This is the Code I have completed: I am...

Q:

X doming UID Conne Baw Dimex Tukho X localhost:8888otebooks/Documents/Python%20Scripts/Task%201%20-%20Sharpening%20Or%20Knivesip.. Bio jupyter Task 1 - Sharpening Our Knives Last Checkpoint a day ago...

Q:

Need help with the following Program in HLA: PLEASE RUN YOUR CODE AND SHOR PROOF ( SCREENSHOTS ) OF THAT IT ACTUALLY WORKS. PROGRAM 1 4 : strlen Function Write an HLA Assembly language program that...

Q:

Getting error when trying to run my code, please help !! when my friend did it he did not get an error and we have the same code... package zipcode; import java.io.File; import...

Q:

Please help me with this question: There's an error when I run this code, it tells me:IndexError: too many indices for array: array is 1-dimensional, but 2 were indexed. How can I solve it? My code:...

Q:

I am working to debug this code. I know I can use the Character.isDigit() to change from a char type to boolean, but when I use it I am still getting an error. Please help. public class CheckInteger...

Q:

A force F1 of magnitude 6.00 units acts at the origin in a direction 30.0 above the positive x axis. A second force F2 of magnitude 5.00 units acts at the origin in the direction of the positive y...

Q:

Find the equation of all planes: (a) Perpendicular to the line [x y z]T = [1 0 -1]T + t[3 0 2]T. (b) Containing P(3, 2, -4). (c) Containing P(2, -1, 1) and Q(l, 0, 0). (d) Containing the line [x y...

Q:

In testing a hypothesis about the difference between two proportions, the p-value is computed to be 0.034. The null hypothesis should be rejected if the chosen level of significance is 0.01.

Q:

What are some of the most important new trends in marketing research? And which do you believe are more relevant to the Turkish market as a whole

Q:

Explain the paradoxes and tensions in pay systems in relation to managing the employment relationship

Q:

Is the proposal from the HR advisor for a differential salary structure favouring law lecturers justifiable?

Q:

How can evaluation of LMD become more than an act of faith?

Previous Question Next Question