Menu
This may sound a noob question, but I'm stuck with it as Python is not one of my best languages.
I have a html page with a table inside it, and I would like to show a pandas dataframe in it. What is the best way to do it? Use pandasdataframe.to_html?
py
from flask import Flask; import pandas as pd; from pandas import DataFrame, read_csv; file = r'C:\Users\myuser\Desktop\Test.csv' df = pd.read_csv(file) df.to_html(header="true", table_id="table") html
<div class="table_entrances" style="overflow-x: auto;"> <table id="table"> <thead></thead> <tr></tr> </table> </div> 
398
To render a Pandas DataFrame to HTML Table, use pandas. DataFrame. to_html() method. The total DataFrame is converted to <table> html element, while the column names are wrapped under <thead> table head html element.
working example:
python code:
from flask import Flask, request, render_template, session, redirect import numpy as np import pandas as pd app = Flask(__name__) df = pd.DataFrame({'A': [0, 1, 2, 3, 4], 'B': [5, 6, 7, 8, 9], 'C': ['a', 'b', 'c--', 'd', 'e']}) @app.route('/', methods=("POST", "GET")) def html_table(): return render_template('simple.html', tables=[df.to_html(classes='data')], titles=df.columns.values) if __name__ == '__main__': app.run(host='0.0.0.0') html:
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> {% for table in tables %} {{titles[loop.index]}} {{ table|safe }} {% endfor %} </body> </html> or else use
return render_template('simple.html', tables=[df.to_html(classes='data', header="true")]) and remove {{titles[loop.index]}} line from html
if you inspect element on html
<html lang="en"><head> <meta charset="UTF-8"> <title>Title</title> </head> <body style=""> <table border="1" class="dataframe data"> <thead> <tr style="text-align: right;"> <th></th> <th>A</th> <th>B</th> <th>C</th> </tr> </thead> <tbody> <tr> <th>0</th> <td>0</td> <td>5</td> <td>a</td> </tr> <tr> <th>1</th> <td>1</td> <td>6</td> <td>b</td> </tr> <tr> <th>2</th> <td>2</td> <td>7</td> <td>c--</td> </tr> <tr> <th>3</th> <td>3</td> <td>8</td> <td>d</td> </tr> <tr> <th>4</th> <td>4</td> <td>9</td> <td>e</td> </tr> </tbody> </table> </body></html>as you can see it has tbody and thead with in table html. so you can easily apply css.
169
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
