Beispiel:
Code: Alles auswählen
import pandas as pd
def fun(col1,col2):
return abs(2*(col2-col1)/(col2+col1))
def paar(row):
return "P" if row['dL'] < 0.002 and row['dR'] < .002 else "-"
data=[(52,872.72,12.66),
(2,883.16,12.46),
(35,881.20,12.50),
(47,881.92,12.50),
(19,874.97,12.71)]
df = pd.DataFrame(data,columns=['ID','L','R'])
ds = df.sort_values(by='L')
ds['dL']=fun(ds['L'],ds['L'].shift(1))
ds['dR']=fun(ds['R'],ds['R'].shift(1))
ds["Paar"] = ((ds['dL'] < 0.2) & (ds['dR'] < 2)).map({True: "P", False: "-"})
ds.style.format({'dL': "{:.2%}",'dR': "{:.2%}"})
print(ds)
ds
----------------
Traceback (most recent call last):
File "<string>", line 23, in <module>
File "/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py", line 899, in style
from pandas.io.formats.style import Styler
File "/usr/local/lib/python3.8/dist-packages/pandas/io/formats/style.py", line 41, in <module>
jinja2 = import_optional_dependency("jinja2", extra="DataFrame.style requires jinja2.")
File "/usr/local/lib/python3.8/dist-packages/pandas/compat/_optional.py", line 110, in import_optional_dependency
raise ImportError(msg) from None
ImportError: Missing optional dependency 'Jinja2'. DataFrame.style requires jinja2. Use pip or conda to install Jinja2.
>
