Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Chemist who falls in acid is absorbed in work.


devel / comp.lang.python / Re: Pandsa to Excel conversion issue

SubjectAuthor
o Re: Pandsa to Excel conversion issueDennis Lee Bieber

1
Re: Pandsa to Excel conversion issue

<mailman.491.1622587169.3087.python-list@python.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=13517&group=comp.lang.python#13517

  copy link   Newsgroups: comp.lang.python
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: wlfr...@ix.netcom.com (Dennis Lee Bieber)
Newsgroups: comp.lang.python
Subject: Re: Pandsa to Excel conversion issue
Date: Tue, 01 Jun 2021 18:13:54 -0400
Organization: IISS Elusive Unicorn
Lines: 38
Message-ID: <mailman.491.1622587169.3087.python-list@python.org>
References: <2118919626.1319748.1622578875491.ref@mail.yahoo.com>
<2118919626.1319748.1622578875491@mail.yahoo.com>
<kgbdbg9l3iefgeircfoef7fusocoeknu94@4ax.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de GYzOdSVF9GP3SU0fBUMriQidlHHkXeNq+YwKHH+8ZR8g==
Return-Path: <python-python-list@m.gmane-mx.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=none reason="no signature";
dkim-adsp=none (unprotected policy); dkim-atps=neutral
X-Spam-Status: OK 0.010
X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'string': 0.05; 'convert':
0.09; 'numpy': 0.09; 'pandas': 0.09; 'parse': 0.09;
'received:ciao.gmane.io': 0.09; 'received:gmane.io': 0.09;
'received:list': 0.09; 'string,': 0.09; "can't": 0.14; 'message-
id:@4ax.com': 0.16; 'object,': 0.16; 'received:116.202': 0.16;
'received:116.202.254': 0.16; 'received:116.202.254.214': 0.16;
'skip:> 20': 0.16; 'subject:issue': 0.16; 'tue,': 0.18; 'to:addr
:python-list': 0.23; 'lines': 0.24; 'code': 0.24; 'tried': 0.26;
'jun': 0.27; 'error': 0.28; 'header:User-Agent:1': 0.31;
'header:Organization:1': 0.31; 'but': 0.31; 'python-list': 0.32;
'raw': 0.32; 'file': 0.38; 'source': 0.38; 'enough': 0.40;
'items': 0.61; 'entire': 0.61; 'above': 0.65; 'compare': 0.69;
'excel': 0.69; 'received:116': 0.71; 'below': 0.71; 'position':
0.74; 'requested': 0.77; '2021': 0.84; 'formatted.': 0.84;
'subject:Excel': 0.84; 'url-ip:76/8': 0.84
X-Injected-Via-Gmane: http://gmane.org/
User-Agent: ForteAgent/8.00.32.1272
X-No-Archive: YES
X-Mailman-Approved-At: Tue, 01 Jun 2021 18:39:27 -0400
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.34
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: <https://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>
X-Mailman-Original-Message-ID: <kgbdbg9l3iefgeircfoef7fusocoeknu94@4ax.com>
X-Mailman-Original-References: <2118919626.1319748.1622578875491.ref@mail.yahoo.com>
<2118919626.1319748.1622578875491@mail.yahoo.com>
 by: Dennis Lee Bieber - Tue, 1 Jun 2021 22:13 UTC

On Tue, 1 Jun 2021 20:21:15 +0000 (UTC), EK Esawi via Python-list
<python-list@python.org> declaimed the following:

>Here is my code
>
>import pandas as pd
>import numpy as np
>
>MyFile='C:/Users/Temp.xlsx'
>df=pd.read_excel(io=MyFile, nrows=100)
>

Paste the first few lines of the Excel file (cut&paste, not image)

Paste the first few lines of the "df" object, so one may compare the
raw data with the imported data.

>
>The error message i get when i tried to convert a string like '22.3' via astype or pd.to_numeric is below
>
>
>Unable to parse string "22." at position 0
>
Paste the entire error message (again, cut&paste TEXT, not a screen
grab). From the above statement alone I can't tell if the " are part of the
string, or just how the error message gets formatted.

{caveat: I don't "do" pandas, but the requested cut&paste items should
provide enough data to scan the Pandas source code and determine what it
may be looking for}

--
Wulfraed Dennis Lee Bieber AF6VN
wlfraed@ix.netcom.com http://wlfraed.microdiversity.freeddns.org/

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor