First, I don't know Python but am using it for a team project. I followed a plaid quickstart tutorial. I was able to create a dataframe with the data I got back, use it to create an html and generate a pdf from that. It took me HOURS! Now I want to apply some basic formatting to the data, like making amounts red if they are negative, right aligning the amount field. I have the code written, but I am not using Jupyter Lab, I am using atom. I have seen a reference to needing style.render() in order to get the changes but don't know how to do it.
This is my code which shows no changes in color in the pdf
# Execute query selecting Transactions table in Plaid database cur.execute("SELECT description, date, amount FROM transactions") # Fetch rows rows = cur.fetchall() # Close cursor cur.close() # Close connection con.close # set negative amounts to red def color_negative_red(amount): color = 'red' if amount < 0 else 'black' return 'color: %s' % color # dataframe df = pd.DataFrame (rows, columns = ["Transaction Description", "Date", "Amount"]) df.style.applymap(color_negative_red) # convert data frame to <table> and display html = df.to_html() text_file = open("test.html", "w") text_file.write(html) text_file.close() # output to a pdf import pdfkit pdfkit.from_file('test.html', 'out.pdf') # open report and pdf in a browser import webbrowser as wb wb.open_new_tab('file://C:/Users/Carole/dev/Plaid/quickstart/python/out.pdf')