My program works with a CSV file with three columns: names, cities, and heights. I need to create a table that determines the difference in height from the average city size. This allows me to decide which two people have the minimum difference from the average. These difference tables must be in Python lists for each city. They must not use tuples, any dictionaries, named functions, or the key or lambda function. To start with, could we try finding the average height in each city? import csv csv_data = [] with open("C:\\Users\\lucas\\Downloads\\sample-data.csv") as f: reader = csv.reader(f) for row in csv.reader(f): csv_data .append(list(row)) f.close() csv_data.pop(0) difference_list = [] def Sorting_cities(data): cities = [] for i in range(len(data)): cities.append(data[i][1]) cities.sort() return cities city_list = Sorting_cities(csv_data) print(city_list) def Listing_cities(cities): single_cities = [] for city in cities: if city not in single_cities: single_cities.append(city) return single_cities unique_cities = Listing_cities(city_list) print(unique_cities) def Counting_cities_and_people(single_cities, cities): people_count = [] for city in single_cities: count = cities.count(city) people_count.append(count) for k in range(len(single_cities)): print(f'City: {single_cities[k]}, Population: {people_count[k]}') return people_count population = Counting_cities_and_people(unique_cities, city_list) print(population) def Find_heights(data): heights = [] for city in unique_cities: for d in data: if city == d[1]: heights.append(int(d[2])) return heights height_list = Find_heights(csv_data) print(height_list) def Find_names(data): names = [] for city in unique_cities: for d in data: if city == d[1]: names.append(d[0]) return names name_list = Find_names(csv_data) def Find_indexes(data): index_list = [] index = 0 for height in data: index_list.append(height) index += 1 return index_list indexes = Find_indexes(csv_data) print(indexes) def Find_average(height_list): local_averages = [] for i in height_list: heights = indexes[i][2] average = sum(heights) / len(heights) if heights == indexes[i][2]: local_averages.append(average) return average avg = Find_average(height_list) print(avg) def Find_difference(): for height in height_list: diff = abs(height - avg) difference_list.append(diff) index = 0 closest_to_average_height = 1000000000 closest_to_average_name = " " second_closest_height = 1000000000 second_closest_name = "placeholder" difference_list_two = difference_list.copy() closest_to_average_diff = 1000000000 second_closest_to_average_diff = closest_to_average_diff difference_list.sort() for index in range(len(height_list)): current_diff = difference_list_two[index] if current_diff <= closest_to_average_diff: second_closest_height = (height_list[index]) r = 0 for index in difference_list_two: if index == difference_list[0]: closest_to_average_diff = index closest_to_average_height = height_list[r] closest_to_average_name = name_list[r] r += 1 newR = 0 for index in difference_list_two: if index == difference_list[1] and name_list[newR] != closest_to_average_name: second_closest_to_average_diff = index second_closest_name = name_list[newR] second_closest_height = height_list[newR] newR += 1 City = "City" most_average = "Most_Average" Height = "Height" next_most = "Second_Most_Average" Next_height = "Height" print(f"{City:^15} {most_average:^25} {Height:^6} {next_most:^25} {Next_height:^6}") print(f'{city:^15} {closest_to_average_name:^25} {closest_to_average_height:^6} ' f'{second_closest_name:^25} {second_closest_height:^6}')

My program works with a CSV file with three columns: names, cities, and heights. I need to create a table that determines the difference in height from the average city size. This allows me to decide which two people have the minimum difference from the average. These difference tables must be in Python lists for each city. They must not use tuples, any dictionaries, named functions, or the key or lambda function.

To start with, could we try finding the average height in each city?

import csv

csv_data = []
with open("C:\\Users\\lucas\\Downloads\\sample-data.csv") as f:
reader = csv.reader(f)
for row in csv.reader(f):
csv_data .append(list(row))
f.close()
csv_data.pop(0)

difference_list = []

def Sorting_cities(data):
cities = []
for i in range(len(data)):
cities.append(data[i][1])
cities.sort()
return cities

city_list = Sorting_cities(csv_data)
print(city_list)

def Listing_cities(cities):
single_cities = []
for city in cities:
if city not in single_cities:
single_cities.append(city)
return single_cities

unique_cities = Listing_cities(city_list)
print(unique_cities)

def Counting_cities_and_people(single_cities, cities):
people_count = []
for city in single_cities:
count = cities.count(city)
people_count.append(count)
for k in range(len(single_cities)):
print(f'City: {single_cities[k]}, Population: {people_count[k]}')
return people_count

population = Counting_cities_and_people(unique_cities, city_list)
print(population)

def Find_heights(data):
heights = []
for city in unique_cities:
for d in data:
if city == d[1]:
heights.append(int(d[2]))
return heights

height_list = Find_heights(csv_data)
print(height_list)

def Find_names(data):
names = []
for city in unique_cities:
for d in data:
if city == d[1]:
names.append(d[0])
return names

name_list = Find_names(csv_data)

def Find_indexes(data):
index_list = []
index = 0
for height in data:
index_list.append(height)
index += 1
return index_list

indexes = Find_indexes(csv_data)
print(indexes)

def Find_average(height_list):
local_averages = []
for i in height_list:
heights = indexes[i][2]
average = sum(heights) / len(heights)
if heights == indexes[i][2]:
local_averages.append(average)

return average

avg = Find_average(height_list)
print(avg)

def Find_difference():
for height in height_list:
diff = abs(height - avg)
difference_list.append(diff)

index = 0

closest_to_average_height = 1000000000
closest_to_average_name = " "
second_closest_height = 1000000000
second_closest_name = "placeholder"

difference_list_two = difference_list.copy()
closest_to_average_diff = 1000000000
second_closest_to_average_diff = closest_to_average_diff

difference_list.sort()

for index in range(len(height_list)):
current_diff = difference_list_two[index]
if current_diff <= closest_to_average_diff:
second_closest_height = (height_list[index])
r = 0
for index in difference_list_two:
if index == difference_list[0]:
closest_to_average_diff = index
closest_to_average_height = height_list[r]
closest_to_average_name = name_list[r]
r += 1
newR = 0
for index in difference_list_two:
if index == difference_list[1] and name_list[newR] != closest_to_average_name:
second_closest_to_average_diff = index
second_closest_name = name_list[newR]
second_closest_height = height_list[newR]
newR += 1
City = "City"
most_average = "Most_Average"
Height = "Height"
next_most = "Second_Most_Average"
Next_height = "Height"

print(f"{City:^15} {most_average:^25} {Height:^6} {next_most:^25} {Next_height:^6}")
print(f'{city:^15} {closest_to_average_name:^25} {closest_to_average_height:^6} '
f'{second_closest_name:^25} {second_closest_height:^6}')