problem in python pandas module

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer01.iad.highwinds-media.com!feed-me.highwinds-media.com!cyclone01.ams2.highwinds-media.com!news.highwinds-media.com!voer-me.highwinds-media.com!newsfeed.eweka.nl!eweka.nl!feeder3.eweka.nl!newsfeed.xs4all.nl!newsfeed1a.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<elearn2014@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.185
X-Spam-Level	*
X-Spam-Evidence	'H': 0.67; 'S': 0.04; 'rows': 0.09; 'subject:module': 0.09; 'filename:fname piece:test': 0.16; 'nan': 0.16; 'subject:python': 0.16; 'import': 0.22; 'subject:problem': 0.24; 'message-id:@mail.gmail.com': 0.30; 'problem': 0.35; 'display': 0.35; 'received:google.com': 0.35; 'there': 0.35; 'to:addr:python-list': 0.38; 'skip:& 20': 0.39; 'to:addr:python.org': 0.39; 'how': 0.40; 'read': 0.60; 'save': 0.62; 'content-type:application/octet-stream': 0.65; 'content- type:image/jpeg': 0.69; 'image-size:2**17': 0.77; 'skip:p 80': 0.84; 'filename:fname piece:JPG': 0.91
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=KudB/7Hz1Pzr/V8e4mu1ZxAhj5P+9LlD0Ks5a6OKK60=; b=1CEj0fJmQbsgagFhZMPOtf3EQCVvMqT8s78ajap7Ycf7apxTZajILk/5kfS+NmA1cT 3x/wcRTrZtLgWJJ15F3sRSmZsxxxo52MbeczSZCoa5OXuWAxaMFn4rP/U3P+109yMX2+ ZbPZALTl/qUH5cpyMuc41d0qEzbigd812FCIQrnN00ipL+gOY/YHJ5as/VK2CqH9nYk1 k/Rw+nfwvzHNbarw5NvWCcsi4jn2ORLAzFZ38iajRyhIvnT0ykEbNqk2HmtVbdMLpimw Enz9HdfHtGhYdTW4hNcDM4KQ7EP/jYm/IAckB81q5b0SPu/3wxSoq/TklwfEfYQlDfC2 UVXQ==
MIME-Version	1.0
X-Received	by 10.152.1.8 with SMTP id 8mr10581401lai.1.1397106198742; Wed, 09 Apr 2014 22:03:18 -0700 (PDT)
Date	Thu, 10 Apr 2014 13:03:18 +0800
Subject	problem in python pandas module
From	length power <elearn2014@gmail.com>
To	python-list@python.org
Content-Type	multipart/mixed; boundary=089e01228132b0b40b04f6a92270
X-Mailman-Approved-At	Thu, 10 Apr 2014 08:46:06 +0200
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.9118.1397112367.18130.python-list@python.org> (permalink)
Lines	1985
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1397112367 news.xs4all.nl 2854 [2001:888:2000:d::a6]:33874
X-Complaints-To	abuse@xs4all.nl
X-Received-Body-CRC	1583489334
X-Received-Bytes	155428
Xref	csiph.com comp.lang.python:70016

Show key headers only | View raw

[Multipart message — attachments visible in raw view] - view raw

the problem about pandas


the data is in the attachment,please download it and save as "test.ansi"

import pandas as pd
pd.read_csv("g:\\test.ansi",sep=",",encoding="gbk")


1.how to read data properly?
there is a balnk line by every data of row.
how can i don't read any   NaN  NaN         NaN ?

2.how to display all data in the console?
there are [301 rows x 3 columns],only 59 of them displayed,how to display
all 301 rows?

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

problem in python pandas module length power <elearn2014@gmail.com> - 2014-04-10 13:03 +0800

csiph-web