[chronojump/michrolab] Added forceSensorCSVFixCalibration.py to fix forceSensor calibration on a dir

[Xavier Padullés <xpadulles src gnome org>]

commit 1229ed9994c3745a8825a7f0c1867cef9e841da9
Author: Xavier de Blas <xaviblas gmail com>
Date:   Tue Sep 13 12:54:21 2022 +0200

    Added forceSensorCSVFixCalibration.py to fix forceSensor calibration on a dir

 python-r-scripts/forceSensorCSVFixCalibration.py | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
---
diff --git a/python-r-scripts/forceSensorCSVFixCalibration.py 
b/python-r-scripts/forceSensorCSVFixCalibration.py
new file mode 100644
index 000000000..c8c24368b
--- /dev/null
+++ b/python-r-scripts/forceSensorCSVFixCalibration.py
@@ -0,0 +1,16 @@
+import pandas as pd
+from os import listdir
+from os import chdir
+
+chdir("forceSensorCSVFixCalibration_files_tofix")
+for filename in listdir():
+    #about pandas_read_csv(engine): https://stackoverflow.com/a/47922247
+    #df = pd.read_csv(filename, sep=";", decimal=",", engine='python')
+    df = pd.read_csv(filename, sep=";", decimal=",")
+    for i, row in df.iterrows():
+        current = float(df.at[i,'Force(N)'])
+        new = ((current -257.13) / 13.4) * 930.59 #obviously, change the values
+        df.at[i,'Force(N)'] = new
+        #print("row: " + str(i) + "; current: " + str(current) + "; new: " + str(new))
+    
+    df.to_csv("../forceSensorCSVFixCalibration_files_fixed/" + filename, sep=';', decimal=",")