Pandas DataFrame to html with JavaScript code gives error

Question

I'm trying to save Pandas DataFrame to html file with embedded JavaScript code for autorefreshing.

My code is:

import pandas as pd

html_string = """
<html>
  <head>
<script>
function timedRefresh(timeoutPeriod) 
{
  setTimeout("location.reload(true);",timeoutPeriod);
}
window.onload = timedRefresh(5000);

</script>

</head>
  <link rel="stylesheet" type="text/css" href="df_style.css"/>
  <body>
    {table}
  </body>
</html>
"""


df1.to_html("/html/calls.html")
    with open('/html/calls.html', 'w') as f:
       f.write(html_string.format(table=df1.to_html(classes='mystyle')))

But i get error:

KeyError: 'setTimeout("location'

Rakesh · Accepted Answer · 2021-05-12 13:00:10Z

1

You need to escape the curly brackets of the JS function. Use double brackets {{}}

Ex:

html_string = """
<html>
  <head>
<script>
function timedRefresh(timeoutPeriod) 
{{
  setTimeout("location.reload(true);",timeoutPeriod);
}}
window.onload = timedRefresh(5000);

</script>

</head>
  <link rel="stylesheet" type="text/css" href="df_style.css"/>
  <body>
    {table}
  </body>
</html>
"""

answered May 12, 2021 at 13:00

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

Collectives™ on Stack Overflow

Pandas DataFrame to html with JavaScript code gives error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related