How to calculate average from text file without numpy or pandas

Question

Here is the code I used to calculate average with numpy and pandas

def calc_average_books_stock():
    
  text_file = open('book_data_file.txt')
    
  values = []
    
  for index,data in df.iterrows():
        
    if int(data['STOCK']) > 0:
            
      values.append(data['COST?'])
    
      avg = np.mean(values)
    
      print(f"Average Book in Stock: {round(avg, 2)}")

I would like to know if there was a way to this without numpy and pandas and just be able to do it with python's standard library

docs.python.org/3/library/statistics.html try statistics?

Anna Semjén
– Anna Semjén

2020-12-04 11:49:11 +00:00
Commented Dec 4, 2020 at 11:49 — Anna Semjén
– Anna Semjén, Commented Dec 4, 2020 at 11:49

Daweo · Accepted Answer · 2020-12-04 11:48:36Z

1

do it with python's standard library You might use .mean from statistics built-in module to calculate average, for example:

import statistics
values = [10, 30, 20]
avg = statistics.mean(values)
print(avg)

output:

answered Dec 4, 2020 at 11:48

Daweo

38.2k3 gold badges17 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris Curvey · Accepted Answer · 2020-12-04 12:02:46Z

0

I'm not 100 sure of where df is coming from, but if your file is in some kind of CSV format, you can replace the pandas with csv.

No need for any the numpy or statistics libraries -- the average is just the sum() divided by the count.

And I think your indentation is off for when you are calculating the mean.

import csv

def calc_average_books_stock():
    
  text_file = open('book_data_file.txt', 'r')

  reader = csv.DictReader(text_file)
    
  values = []
    
  for data in reader:
        
    if int(data['STOCK']) > 0:
            
      values.append(data['COST?'])
    
  avg = sum(values) / len(values)
    
  print(f"Average Book in Stock: {round(avg, 2)}")

answered Dec 4, 2020 at 12:02

Chris Curvey

10.5k14 gold badges53 silver badges75 bronze badges

Collectives™ on Stack Overflow

How to calculate average from text file without numpy or pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related