format string in pandas dataframe 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’}”)