Skip to content

10 #16

Description

@legend17-dot

import csv
def read_csv(file_name):
data=[]
with open(file_name,'r')as file:
reader=csv.DictReader(file)
for row in reader:
data.append(row)
return data
def get_column(data,column):
values=[]
for row in data:
try:
values.append(float(row[column]))
except:
return values
def get_max(values):
return max(values)
def get_min(values):
return min(values)
def get_avg(values):
return sum(values)/len(values)

file_name=input("Enter CSV file name:")
data=read_csv(file_name)
print("Available columns:",list(data[0].keys()))
column=input("Enter column name for analysis:")
values=get_column(data,column)
if not values:
print("No numeric data found in this column.")
else:
print("\n---summary--")
print("Max;",get_max(values))
print("Min:",get_min(values))
print("Average:",get_avg(values))


import csv

def read_csv(file_name):
data = []

with open(file_name, mode='r') as file:
    reader = csv.DictReader(file)

    for row in reader:
        data.append(row)

return data

def get_column(data, column):
values = []

for row in data:
    try:
        values.append(float(row[column]))
    except:
        pass

return values

def get_max(values):
return max(values)

def get_min(values):
return min(values)

def get_avg(values):
return sum(values) / len(values)

file_name = input("Enter CSV file name: ")

data = read_csv(file_name)

print("Available columns:", list(data[0].keys()))

column = input("Enter column name for analysis: ")

values = get_column(data, column)

if not values:
print("No numeric data found in this column.")
else:
print("\n--- Summary ---")
print("Max:", get_max(values))
print("Min:", get_min(values))
print("Average:", get_avg(values))

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions