pandas format string code example

Example: string df format pandas

df.head(10).style.format({"BasePay": "${:20,.0f}",                          
                          "OtherPay": "${:20,.0f}",                           
                          "TotalPay": "${:20,.0f}",                         
                          "TotalPayBenefits":"${:20,.0f}"})\                 
                  .format({"JobTitle": lambda x:x.lower(),                          
                           "EmployeeName": lambda x:x.lower()})\                 
                  .hide_index()\                 
                  .applymap(lambda x: f”color: {‘red’ if isinstance(x,str) else ‘black’}”)