Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

We don't know one millionth of one percent about anything.


devel / comp.lang.python / SQLAlchemy fault

SubjectAuthor
o SQLAlchemy faultShaozhong SHI

1
SQLAlchemy fault

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

  copy mid

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

  copy link   Newsgroups: comp.lang.python
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: shishaoz...@gmail.com (Shaozhong SHI)
Newsgroups: comp.lang.python
Subject: SQLAlchemy fault
Date: Wed, 20 Oct 2021 10:31:58 +0100
Lines: 19
Message-ID: <mailman.984.1634722339.4164.python-list@python.org>
References: <CA+i5JwZ597OAhOE-_TWR2kL=K68ZYPbzhis3qzFDGtNioW5rTQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
X-Trace: news.uni-berlin.de TJWzB85DLwCAIIWIxANNcQU/30yWuXHswDNs5bkSTKbg==
Return-Path: <shishaozhong@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=pass
reason="2048-bit key; unprotected key"
header.d=gmail.com header.i=@gmail.com header.b=cH0lgDHa;
dkim-adsp=pass; dkim-atps=neutral
X-Spam-Status: OK 0.143
X-Spam-Level: *
X-Spam-Evidence: '*H*': 0.73; '*S*': 0.01; 'pandas': 0.09; 'column':
0.16; 'received:209.85.208.42': 0.16; 'received:mail-
ed1-f42.google.com': 0.16; 'to:addr:python-list': 0.20; 'anyone':
0.25; 'modified': 0.32; 'message-id:@mail.gmail.com': 0.32;
'mean': 0.34; 'received:google.com': 0.34; 'from:addr:gmail.com':
0.35; 'received:209.85': 0.37; 'file': 0.38; 'read': 0.38;
'received:209': 0.39; 'received:209.85.208': 0.39; 'skip:h 10':
0.61; '8bit%:31': 0.73; '8bit%:25': 0.80; 'happened.': 0.84
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112;
h=mime-version:from:date:message-id:subject:to;
bh=MqQsHc0rl8GqV/ag/3kdfB91hmro5znOtsTMcpfry2U=;
b=cH0lgDHaAlXZN06v0l9JKRbzC+ojBJf3iW4FG8Gq5FmKJFOHPiX6zgFaIW3II72KfT
ku51z4CICmxhGmJklXgtmVtBjap0uVgHiuDcf4wIIsaohGjX9Q6zv5uDAbpBjlvyVoB/
PcajTWwZ+vZdXbrSY6/GxxlG3rf8o/Qaqsno8XtLug4ebmja625NxIxA32sUYfhLp2dL
vSijVUfk1NX6c8pfBQH3s2/qy3hJKZoy0Od89g/83eTsPkSVMZPNkG3nl7grR/V4x1R3
vle1S3bFk6P++6mYoBUgs3j3uWXmtVcgympIPCIZBNIGw9TiZbpWHw6G8LAIHKLHmC7Z
AGqA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20210112;
h=x-gm-message-state:mime-version:from:date:message-id:subject:to;
bh=MqQsHc0rl8GqV/ag/3kdfB91hmro5znOtsTMcpfry2U=;
b=JrCFGfgR6pGouSR75uyIgY7dLRu16TSim9uViOrt0/tQYWUcUNjUTR0y7xkQTo/iIJ
pjX7UrxdkWpMY4XFdYEkO+Ygpj3t2+05BCxDF7ZOQ7ivzkrSgns/CRuo7l/7k2Py1QQm
1ilga/viy9nQPYEh+UKBGy9SqulN20eTIU2kpg5uxAfTy/MWNfcS9+u3rMPKTEa/QN8M
6j0JetR/r5GxCSVka6G6Qrf5uCLYxe0hYKRKJ3WtYY7pvjM1gFxY18BV/r5tpiRtxMnz
adhbCvSmq156rWtWx4qExRwZkyf8k779oZoQD5/jJpk+nf7s+RnYfgqGB6R5oe6F5lY/
eTsA==
X-Gm-Message-State: AOAM533c0EPAwVjqHeqPlJZFlyZTopzjzSaGPEgQ8u4eZWthjv1AG8a/
FoO/PZIfdkhLE5nsnvwvCQVzJSoO1GcKDjyyhjGmEE1RfM0=
X-Google-Smtp-Source: ABdhPJwwsOmnsZTwI6DU5M/VxmIvmm+B7vYtVQLWbqUW4o0m7OX+CljuwEwWEEnSTUaPWTb4SNzYQrBRO/Dsrpngw1k=
X-Received: by 2002:a05:6402:1e88:: with SMTP id
f8mr61914758edf.86.1634722329341;
Wed, 20 Oct 2021 02:32:09 -0700 (PDT)
X-Content-Filtered-By: Mailman/MimeDel 2.1.34
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: <CA+i5JwZ597OAhOE-_TWR2kL=K68ZYPbzhis3qzFDGtNioW5rTQ@mail.gmail.com>
 by: Shaozhong SHI - Wed, 20 Oct 2021 09:31 UTC

I read a txt file into Pandas Dataframe, and found a lot of nulls in a
column.

Then, I used SQLAlchemy and psycopg2. I created engine.

I loaded data onto PostgreSQL.

Strange thing happened.

The column has no null at all.

Does it mean that the data has been modified somewhere along the line?

Does anyone know the robust and fast loading of Pandas frame data onto
Postgres database?

Regards,

David

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor