Das deutsche Python-Forum

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.
>