displaying table in html using 'for' loop from render_template()

Question

Using Python Flask app to render a html table with 'for' loop implementation. But the data doesn't render giving a blank <tr><tr>.

I am converting a dataframe to html by passing a dff.to_html() from render_template and retrieving the table in html in a 'for' loop to display.

Python code:

return render_template('index.html', table = dff.head(50).to_html())

html code:

         <table>
            <tbody>

            {% for row in table %}
                <tr>
                    <td>{{row.name}}</td>
                    <td>{{row.link_to_detail}}</td>
                    <td>{{row.link}}</td>
                    <td><input name ="get poster"  type="submit" value={{row['id']}}></td>
                </tr>
            {% endfor %}
            </tbody>
        </table>

Actual result is

<tr>
      <td></td>
      <td></td>
      <td></td>
      <td><input name="get poster" type="submit" value=""></td>
</tr>

Expected result :

    <tr>
      <td>name</td>
      <td>link_to_detail</td>
      <td>link</td>
      <td><input name="get poster" type="submit" value=""></td>
    </tr>

'''

table is a string with HTML so you can use {{ table }} to put it in template. — furas
– furas, Commented Jul 4, 2019 at 12:43

olinox14 · Accepted Answer · 2019-07-04 12:40:16Z

2

dff.head(50).to_html() returns an html table, not a python object.

This html table is actually a string, and you are iterating over characters (row), which do not have any attributes called name, link or link_to_detail...

I'll be able to complete this answer if you post a sample of your dff dataframe.

answered Jul 4, 2019 at 12:40

olinox14

6,7223 gold badges27 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tronic · Accepted Answer · 2019-07-04 12:43:52Z

0

Do not use dff.head().to_html() which returns an HTML table as a string, but instead dff[:50].values (gives you 2d-array of all columns of the first 50 rows) and then row.0 and row.1 to get the values of the first two columns on each row.

answered Jul 4, 2019 at 12:43

Tronic

1,42615 silver badges16 bronze badges

Comments

sem · Accepted Answer · 2019-07-04 12:41:32Z

0

I have never work python but idea is you need to send variables to view.

return render_template('index.html', table = dff.head(50).to_html(),  name='name' ,row.link_to_detail= 'row.link_to_detail' , link ='link')

it can be like this

answered Jul 4, 2019 at 12:41

sem

615 bronze badges

Collectives™ on Stack Overflow

displaying table in html using 'for' loop from render_template()

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related