Compute mean volume
df = pd.read_csv("data/{}.csv".format(symbol)) # read in data
s = sum(df)
l = len(df)
print(s/l)
unsupported operand type(s) for +: 'int' and 'str'
TypeError showed.
We must calculate dataframe mean.
import pandas as pd
def get_mean_volume(sympol):
df = pd.read_csv("data/{}.csv".format(symbol))
print(df.mean())
def test_run():
for symbol in ['AAPL', 'IBM']:
print "Mean Volume"
print symbol, get_mean_volume(symbol)
if __name__ == "__main__": # if run standalone
test_run()
Mean Volume AAPL Open 1.363176e+02 High 1.380075e+02 Low 1.344201e+02 Close 1.362885e+02 Volume 2.149143e+07 Adj Close 1.282174e+02 dtype: float64 None Mean Volume IBM Open 1.109328e+02 High 1.121182e+02 Low 1.098853e+02 Close 1.110325e+02 Volume 7.103571e+06 Adj Close 1.022113e+02 dtype: float64 None
Here is a solution
import pandas as pd
def get_mean_volume(sympol):
df = pd.read_csv("data/{}.csv".format(symbol))
return df['Volume'].mean()
def test_run():
for symbol in ['AAPL', 'IBM']:
print "Mean Volume"
print symbol, get_mean_volume(symbol)
if __name__ == "__main__": # if run standalone
test_run()
Mean Volume AAPL 21491431.3386 Mean Volume IBM 7103570.80315