pandas.read_html not support decimal comma
<p>I was reading an xlm file using <code>pandas.read_html</code> and works <strong>almost perfect</strong>, the problem is that the file has commas as decimal separators instead of dots (the default in <code>read_html</code>). </p>

<p>I could easily replace the commas by dots in one file, but i have almost 200 files with that configuration. 
with <code>pandas.read_csv</code> you can define the decimal separator, but i don't know why in <code>pandas.read_html</code> you can only define the thousand separator. </p>

<p>any guidance in this matter?, there is another way to automate the comma/dot replacement before it is open by pandas? 
thanks in advance! </p>

<p>Thanks @zhqiat. I think upgrading <code>pandas</code> to version <code>0.19</code> will solve the problem. unfortunately I couldn't found an easy way to accomplish that. I found a tutorial to upgrade Pandas but for <a href="http://askubuntu.com/questions/70883/how-do-i-install-python-pandas/70885">ubuntu</a> (winXP user).</p>

<p>I finally chose the workaround, using the method posted <a href="http://stackoverflow.com/a/17550789/5318634">here</a>, basically converting all columns, one by one, to a numeric type of <code>pandas.Series</code></p>

<pre><code>result[col] = result[col].apply(lambda x: x.str.replace(".","").str.replace(",","."))
</code></pre>

<p>I know that this solution ain't the best, but works. Thanks</p>

python pandas decimal xlm