[Tutor] NumPy Generates ValueError: Some errors were detected ! Line #9 (got 42 columns instead of 1)

[Alan Gauld]

On 29/09/2019 01:44, David wrote:
> On Sun, 29 Sep 2019 at 02:36, Stephen P. Molnar <s.molnar at sbcglobal.net> wrote:
>> On 09/27/2019 12:22 PM, Alan Gauld via Tutor wrote:
>>
>> Thank you for your reply. There are, in fact, hidden characters in the
>> input file (cat -A ...):
>>
>>> ^IRMSD TABLE$
>>> ^I__________$
>>> $
>>> _____________________________________________________________________$
>>>      |      |      |           |         |                 |$
>>> Rank | Sub- | Run  | Binding   | Cluster | Reference       | Grep$
>>>      | Rank |      | Energy    | RMSD    | RMSD            | Pattern$
>>> _____|______|______|___________|_________|_________________|___________$
>>>    1      1      8       -7.23      0.00     93.07 RANKING$
>>>    1      2      9       -6.79      1.39     92.64 RANKING$
>>>
>>> But I wonder why you say "There are, in fact, hidden characters in the
>>> input file".
>>>
>>> Are you aware that '^I' is how 'cat -A' represents a tab
>>> character, and that '$' is how it represents a newline character?


The hidden characters from my perspective were the spaces betweenthe fields.

In the original post I saw:

|RMSD TABLE __________ 
_____________________________________________________________________ 
||||||Rank|Sub-|Run|Binding|Cluster|Reference|Grep|Rank||Energy|RMSD 
|RMSD 
|Pattern_____|______|______|___________|_________|_________________|___________ 
118-7.230.0093.07RANKING 129-6.791.3992.64RANKING 
2116-7.180.0093.19RANKING 312-6.930.0093.38RANKING 

So it looked like the field separator was the periods.
Which, coincidentally, led to 7 fields exactly as the error 
message stated.

Seeing the spaces gives an entirely different view of the data!


-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos