Appending DF to the CSV - How to write everything explicitly without any conversion whatsoever?

Question

I searched and found this answer While I understand the answer, my question is: Are there any possible ways to write data from DF explicitly to CSV and without any possible conversion? Is there an option to do that?

Example, value ".227" is stored to CSV as "022699999999999998"

I have this simple code, after scraping some data with BS, I open it in DF and then write to CSV:

table = soup.find('table', id='awer')
df1 = pd.read_html(str(table))
df1[0]['seas'] = season
print(df1[0])
df1[0].to_csv('abc.csv', encoding='utf=8', index=False, header=None , mode='a')

To verify, before appending I have printed out DF and everything is fine. So there is some kind of a conversion ongoing while appending data to CSV.

Any ideas how to solve it?

Thanks

what's the type of the `column` which is holding your `float` ? , you just have to use `float_format='%.3f'` — αԋɱҽԃ αмєяιcαη, Mar 31 '20 at 13:10
Is the number ``.227`` stored as ``022699999999999998`` or as ``0.22699999999999998``? — MisterMiyagi, Mar 31 '20 at 13:18
@MisterMiyagi I believe it's already `float` where he meant to say `0.227` is stored as `0.022699999999999998`, that's why he mentioned the `.` — αԋɱҽԃ αмєяιcαη, Mar 31 '20 at 13:19
Hi @MisterMiyagi, as I wrote `.227` is stored as `022699999999999998` — botafogo, Mar 31 '20 at 13:51

score 0 · Answer 1 · answered Mar 31 '20 at 13:26

0

Do you mean something like df.astype('unicode')?

answered Mar 31 '20 at 13:26

gosuto

5,422
6
36
57

Appending DF to the CSV - How to write everything explicitly without any conversion whatsoever?

1 Answers1