I am phD students in Hiroshima University, Japan. I try to use web2py to establish an app for my research about environment management of the Seto Inland Sea,Japan. In the app, users upload their csv data, and will get the results here is my controller file and view file #controller data.py def data(): import numpy as np import pandas as pd dat = pd.read_csv('C:\Users\XX\Desktop\TEST.csv') sal = dat['salinity'] N2 = dat['N2'] chl = dat['chla'] return dict(sal=sal, N2=N2, chl=chl) #data/data html {{extend 'layout.html'}} #show the raw data <h1>这是 This is raw data</h1> <h5>sal={{=sal}}</h5> <h5>N2={{=N2}}</h5> <h5>chl={{=chl}}</h5> {{import numpy as np}} {{from scipy.optimize import leastsq}} #calculation #data standardization {{s_sal=((chl-np.mean(sal))/np.std(sal))}} {{s_N2=((chl-np.mean(N2))/np.std(N2))}}
#model fitting by leastsq {{def func1(t,x,y):}} {{return 1/(t[0]+t[1]*np.exp(t[2]*x))-y}} {{t0=np.array([1.0,1.0,1.0])}} {{for i in np.arange(0,2.0,0.05):}} {{index = i*s_sal + (2-i)*s_N2}} {{cf = leastsq(func1,t0,args=(index,chl))}} #show the results <li> "Model: "{{=i}}"*salinity+"{{=2-i}}"*N2" "Equation: 1/("{{=round(cf[0][0],2)}}"+"{{=round(cf[0][1],2)}}"*EXP("{{=round(cf[0][2],2)}}"*x))" </li> {{pass}} I am fresh in coding work and web development, so some easy problems in this field is difficult for me. In this case what should I add in Model part (database) and how to get the csv content from the corresponding database. Thanks all. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.