+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: looping calculation in dataframe (/thread-25137.html)
looping calculation in dataframe - duncipe - Mar-21-2020
Hi,
I'm used to working with R but new to Python (except Think Python).
I wrote codes for various river cross section analysis in R and now want to transfer them to Python in order to compile them to executeables but I struggle with the first simple task:
I have a txt with the geometry as input (x being the lateral distance and y the elevation)
0,4
3,3
4,0
6,1
7,3
10,4
I want to calculate the area A for each step i: Ai= (yi+yi-1)*(xi-xi-1)/2
And store the value in a new column. How do I do this in Python? When storing x and y in seperate arrays, I'm struggling in adreessing them correctly in loops for example.
In R I could simply adress it i.e. data[i,1] or data[i-1,1]
Thank you
RE: looping calculation in dataframe - buran - Mar-21-2020
there are different ways, depending on what libraries you use. What have you tried? Do you use external libraries like
pandas, or do you use just modules from python standard library like csv
RE: looping calculation in dataframe - duncipe - Mar-21-2020
I tried to go with numpy