/basictests/usingpandas.py

https://bitbucket.org/lstorchi/teaching · Python · 19 lines · 15 code · 4 blank · 0 comment · 2 complexity · ff82876380a799a5d7411074a5320bc5 MD5 · raw file 

    

  1. import pandas
    2. 

  2. import numpy
    3. 

  3. import sys
    4. 

  4. import re
    5. 

  5. 

  6. filename = ""
    7. 

  7. if len(sys.argv) == 2:
    8. 

  8.     filename = sys.argv[1]
    9. 

  9. else:
    10. 

  10.     print "usage: ", sys.argv[0], " filename.txt"
    11. 

  11.     exit(1)
    12. 

  12. 

  13. df = pandas.read_excel(filename)
    14. 

  14. cn = df.columns
    15. 

  15. 

  16. print "CN: ", cn
    17. 

  17. 

  18. values = numpy.asarray(df[cn[0]].values)
    19. 

  19. print numpy.mean(values), " ", numpy.std(values)
    20.