Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Could you help to check the error? Because when i run the code, it tells me :ValueError: could not convert string ' 2 0 2

Could you help to check the error? Because when i run the code, it tells me :ValueError: could not convert string '2023-01-01' to float64 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('data_temperature.txt', delimiter=',', 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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions