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