python pandas csv to html UnicodeEncodeError

Question

I was trying to convert a csv data to html using Pandas. But i was getting the below error UnicodeEncodeError('ascii', u'', 10305, 10306, 'ordinal not in range(128)')

How to resolve this issue

Please share your inputs and outputs of code

Rachit kapadia
– Rachit kapadia

2018-04-03 13:54:59 +00:00
Commented Apr 3, 2018 at 13:54 — Rachit kapadia
– Rachit kapadia, Commented Apr 3, 2018 at 13:54

Gustav Rasmussen · Accepted Answer · 2018-04-03 20:07:06Z

1

Importing the pandas module:

import pandas as pd

I create an example csv-file, "odd_numbers.csv", containing the odd numbers from 1 to 9:

1,3,5,7,9

First convert your CSV file (here "odd_numbers.csv") into a Pandas Dataframe, "df":

filename      = "odd_numbers.csv"
df            = pd.read_csv(filename, header = None)

Then use Pandas to_html function on your new dataframe, "df", and make sure to set the "classes" argument for this function equal to "utf8":

HTML_file    = df.to_html(classes='utf8')

The HTML file, "HTML_file", will then contain the following:

<table border="1" class="dataframe utf8">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>0</th>
      <th>1</th>
      <th>2</th>
      <th>3</th>
      <th>4</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>1</td>
      <td>3</td>
      <td>5</td>
      <td>7</td>
      <td>9</td>
    </tr>
  </tbody>
</table>

edited Apr 3, 2018 at 20:07

answered Apr 3, 2018 at 14:04

Gustav Rasmussen

4,0394 gold badges32 silver badges56 bronze badges

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

3 Comments

Anuraagmadhav.r Over a year ago

At df.to_html step am facing the issue of "UnicodeEncodeError('ascii', u'', 10305, 10306, 'ordinal not in range(128)')"

Gustav Rasmussen Over a year ago

Set your 'classes' argument, inside Pandas to_html method, to 'utf8'. In the above example: HTML_file = df.to_html(classes='utf8')

Anuraagmadhav.r Over a year ago

When am trying to push the HTML data (df.to_html(classes='utf8') ) into a .html file still facing the same issue UnicodeEncodeError

Collectives™ on Stack Overflow

python pandas csv to html UnicodeEncodeError

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related