StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POreading and writing csv in pandas changes cell values
primarykey
Id
15879992
data
AcceptedAnswerId
19566601
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-04-08T13:12:07.830
FavoriteCount
0
LastActivityDate
2013-10-24T12:57:17.200
LastEditDate
2013-04-08T18:57:51.773
LastEditorUserId
2006977
OwnerUserId
2006977
ParentId
0
PostTypeId
1
Score
0
ViewCount
758
LastEditorDisplayName
text
Body
I've just started learning pandas and noticed a very strange behaviour, reading and writing csv files changes the values of the cells of the data frame. before: <pre><code>64437311025 SMP 1 110.00 0.00 498.00 4174.3865 4243.59 4247.69 4424.62 4570.26 3874.36 4516.41 4412.31 4117.44 4215.38 4300.00 4433.85 4065.64 4394.36 1728.00 1675.00 1517.27 1363.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 0 0 0 0.00 0 0.00 </code></pre> after issuing: <pre><code>df = pd.read_csv(in_file, sep='\t') df.to_csv(out_file, sep='\t') </code></pre> I get: <pre><code>1 64437311025 SMP 1 110.0 0.0 498.0 4174.3864999999996 4243.5900000000001 4247.6899999999996 4424.6199999999999 4570.2600000000002 3874.3600000000001 4516.4099999999999 4412.3100000000004 4117.4399999999996 4215.3800000000001 4300.0 4433.8500000000004 4065.6399999999999 4394.3599999999997 1728.0 1675.0 1517.27 1363.23 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 0 0.0 </code></pre> I'd be grateful for any suggestions as to what I'm doing wrong. I'm using standard installation of Python (2.7.3) and pandas from ubuntu 12.10 repositories (0.8.0) EDIT: i think it is a bug: <a href="https://github.com/pydata/pandas/issues/2069" rel="nofollow">https://github.com/pydata/pandas/issues/2069</a> thanks to user1827356 I found the float_format argument to to_csv method, but to make it work I had to install newer version of pandas, since it was not working in default 0.8 pandas in ubuntu 12.10. it's ok now. thanks!
Tags
<python><pandas>
Title
reading and writing csv in pandas changes cell values
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USyemu
UserOwnerUserId
1. USyemu
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.