Convert pandas dataframe to html table

Question

I am working on a django application. In the application I am trying to display a pandas dataframe in a django template. I am loading a csv file as follows.

df = pd.read_csv(os.path.join(path, str(request.FILES['file'])))
table_content = df.to_html()
context = {'table_content': table_content}
return render(request, 'index.html', context)

The problem I am facing is when I try to display the table. In the template I am retrieving the dataframe as {{table_content}}. But this just displays the html code for the table and not the table itself. I can do a HttpResponse to display the table, but then the rest of the content in the template disappears and only the table is displayed.

What am I doing wrong?

Harris Mirza · Accepted Answer · 2019-02-18 11:18:55Z

3

You can use autoescape (https://docs.djangoproject.com/en/dev/ref/templates/builtins/#autoescape)

{% autoescape off %}{{ table_content }}{% endautoescape %}

answered Feb 18, 2019 at 11:18

Harris Mirza

761 silver badge15 bronze badges

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

1 Comment

Asher Over a year ago

This will work. You can also use {{ table_content|safe }}

Collectives™ on Stack Overflow

Convert pandas dataframe to html table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related