从csv中提取的数据获得平均值

没有 mean 函数。您需要在列表中获取这些值,然后将这些值求和并除以它们的长度。列表理解会很好地发挥作用。

city = open('ciudades.csv')
lineas = csv.reader(city)

populations = [
  int(population)
  for a, name, countrycode, district, population in lineas
  if countrycode == 'AFG'
]

avg = sum(populations) / len(populations)

以下是如何实现这一目标的分步指南:

• 读取CSV文件并提取指定条件的总体数据。

• 将填充数据从字符串转换为整数。

• 计算平均人口。

    import csv
  
    # Open the CSV file
    with open('ciudades.csv') as city:
        lineas = csv.reader(city)
  
        # Initialize an empty list to store populations
        populations = []
  
        # Iterate through the rows of the CSV file
        for a, name, countrycode, district, population in lineas:
            # Check if the country code is 'AFG'
            if countrycode == 'AFG':
                # Convert population to integer and add to the list
                populations.append(int(population))
  
        # Calculate the average population
        if populations:
            average_population = sum(populations) / len(populations)
            print(f"The average population is {average_population}")
        else:
           print("No data found for the specified condition.")