When pd.read_csv(csvstring, sep=r'\s+') doesn't work ...
Project description
When pd.read_csv(csvstring, sep='\s+') doesn't work ...
pip install a-pandas-ex-csv-plus
from a_pandas_ex_csv_plus import pd_add_convert_to_df
pd_add_convert_to_df()
import pandas as pd
xaxa='''
2020-09-1022-30-03.mp4 2020-10-08 18-54-44.mp4 2020-10-14 19-46-34.mp4
2020-09-1022-30-10.mp4 2020-10-08 18-56-39.mp4 2020-10-17 12-11-54.mp4
2020-09-1022-30-13.mp4 2020-10-17 13-23-56.mp4
2020-09-1022-30-33.mp4
2020-09-1022-30-38.mp4
2020-09-1022-30-41.mp4 2020-10-17 13-30-27.mp4
2020-09-1022-31-03.mp4 2020-10-1115-49-19.mp4 2020-10-17 13-30-28.mp4
2020-09-1022-31-36.mp4 2020-10-1116-10-45.mp4 2020-10-17 13-30-41.mp4
2020-10-11 16-34-20.mp4 acesseoscursos.mp4
2020-10-1116-48-08.mp4 acesseoscursoscelular.mp4
2020-10-11 19-00-47.mp4 reaberturatrailer.mp4
2020-10-1119-08-19.mp4 rexmega.mp4
2020-10-0818-54-37.mp4 2020-10-1119-17-33.mp4
'''
## Pure Pandas - probably not what you want:
print(pd.read_csv(StringIO(xaxa), sep=r'\s+', on_bad_lines='skip').to_string())
2020-09-1022-30-03.mp4 2020-10-08 18-54-44.mp4 2020-10-14 19-46-34.mp4
0 2020-09-1022-30-10.mp4 2020-10-08 18-56-39.mp4 2020-10-17 12-11-54.mp4
1 2020-09-1022-30-13.mp4 2020-10-17 13-23-56.mp4 NaN NaN
2 2020-09-1022-30-33.mp4 NaN NaN NaN NaN
3 2020-09-1022-30-38.mp4 NaN NaN NaN NaN
4 2020-09-1022-30-41.mp4 2020-10-17 13-30-27.mp4 NaN NaN
5 2020-09-1022-31-03.mp4 2020-10-1115-49-19.mp4 2020-10-17 13-30-28.mp4 NaN
6 2020-09-1022-31-36.mp4 2020-10-1116-10-45.mp4 2020-10-17 13-30-41.mp4 NaN
7 2020-10-11 16-34-20.mp4 acesseoscursos.mp4 NaN NaN
8 2020-10-1116-48-08.mp4 acesseoscursoscelular.mp4 NaN NaN NaN
9 2020-10-11 19-00-47.mp4 reaberturatrailer.mp4 NaN NaN
10 2020-10-1119-08-19.mp4 rexmega.mp4 NaN NaN NaN
11 2020-10-0818-54-37.mp4 2020-10-1119-17-33.mp4 NaN NaN NaN
df = pd.Q_convert_to_df(string_table=xaxa, regex_sep=r"\s+", tolerance=1)
print(df.to_string())
0 2 3
0 2020-09-1022-30-03.mp4 2020-10-08 18-54-44.mp4 2020-10-14 19-46-34.mp4
1 2020-09-1022-30-10.mp4 2020-10-08 18-56-39.mp4 2020-10-17 12-11-54.mp4
2 2020-09-1022-30-13.mp4 2020-10-17 13-23-56.mp4
3 2020-09-1022-30-33.mp4
4 2020-09-1022-30-38.mp4
5 2020-09-1022-30-41.mp4 2020-10-17 13-30-27.mp4
6 2020-09-1022-31-03.mp4 2020-10-1115-49-19.mp4 2020-10-17 13-30-28.mp4
7 2020-09-1022-31-36.mp4 2020-10-1116-10-45.mp4 2020-10-17 13-30-41.mp4
8 2020-10-11 16-34-20.mp4 acesseoscursos.mp4
9 2020-10-1116-48-08.mp4 acesseoscursoscelular.mp4
10 2020-10-11 19-00-47.mp4 reaberturatrailer.mp4
11 2020-10-1119-08-19.mp4 rexmega.mp4
12 2020-10-0818-54-37.mp4 2020-10-1119-17-33.mp4
xaxa2 = """
com.blues 2003 system mem unknown /dev/ashmem/dalvik-LinearAlloc (deleted)
com.blues 2003 system mem CHR 10,60 7622 /dev/binder
com.blues 2003 system mem unknown /dev/ashmem/dalvik-indirect ref table (deleted)
com.blues 2003 system mem unknown /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)
com.blues 2003 system mem REG 8,1 8774704 263011 /system/lib/libart.so
com.blues 2003 system mem REG 8,1 29176 263435 /system/fonts/NotoSansLao-Bold.ttf
com.blues 2003 system mem REG 8,1 411120 262703 /system/lib/libinputflinger.so
com.andro 19725 u0_a54 cwd DIR 0,2 820 2 /
com.andro 19725 u0_a54 rtd DIR 0,2 820 2 /
com.andro 19725 u0_a54 txt REG 8,1 17948 262260 /system/bin/app_process32
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-main space (deleted)
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-main space 1 (deleted)
com.andro 19725 u0_a54 mem REG 8,17 2125824 2228227 /data/dalvik-cache/x86/system@framework@boot.art
com.andro 19725 u0_a54 mem REG 8,17 1167360 2228229 /data/dalvik-cache/x86/system@framework@boot-core-libart.art
com.andro 19725 u0_a54 mem REG 8,1 5142 263912 /system/usr/hyphen-data/hyph-mn-cyrl.hyb
com.andro 19725 u0_a54 mem REG 8,1 35913 263879 /system/usr/hyphen-data/hyph-cy.hyb
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem REG 8,1 67076 262937 /system/lib/libkeymaster_messages.so
com.andro 19725 u0_a54 mem REG 8,1 202252 262648 /system/lib/libkeymaster1.so
com.andro 19725 u0_a54 mem REG 8,1 160904 262967 /system/lib/libsoftkeymasterdevice.so
com.andro 19725 u0_a54 mem REG 8,1 156172 262657 /system/lib/libjavacrypto.so
com.andro 19725 u0_a54 mem REG 8,1 124456 263004 /system/lib/libkeystore_binder.so
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem REG 0,15 131072 6346 /dev/__properties__/u:object_r:logd_prop:s0
com.andro 19725 u0_a54 mem REG 0,15 131072 6339 /dev/__properties__/u:object_r:default_prop:s0
com.andro 19725 u0_a54 mem REG 8,1 8165 263886 /system/usr/hyphen-data/hyph-fr.hyb
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem REG 8,1 607 263890 /system/usr/hyphen-data/hyph-pa.hyb
com.andro 19725 u0_a54 mem REG 8,1 9716 262949 /system/lib/libkeystore-engine.so
com.andro 19725 u0_a54 mem REG 8,1 647 263924 /system/usr/hyphen-data/hyph-or.hyb
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem REG 8,1 518036 262595 /system/lib/libmedia_jni.so
com.andro 19725 u0_a54 mem REG 8,1 202168 263023 /system/lib/libexif.so
com.andro 19725 u0_a54 mem REG 8,1 136632 262593 /system/lib/libmtp.so
com.andro 19725 u0_a54 mem REG 8,1 71116 263050 /system/lib/libstagefright_amrnb_common.so
com.andro 19725 u0_a54 mem REG 8,1 687 263891 /system/usr/hyphen-data/hyph-mr.hyb
com.andro 19725 u0_a54 mem REG 0,15 131072 6352 /dev/__properties__/u:object_r:log_prop:s0
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem REG 8,1 504430 263754 /system/usr/share/zoneinfo/tzdata
com.andro 19725 u0_a54 mem REG 8,1 18677700 263362 /system/fonts/NotoSansCJK-Regular.ttc
com.andro 19725 u0_a54 mem REG 8,1 6967 263882 /system/usr/hyphen-data/hyph-da.hyb
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
com.andro 19725 u0_a54 mem REG 8,1 40308 263449 /system/fonts/CarroisGothicSC-Regular.ttf
com.andro 19725 u0_a54 mem REG 8,1 22201456 263865 /system/usr/icu/icudt56l.dat
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-LinearAlloc (deleted)
com.andro 19725 u0_a54 mem REG 8,17 1663816 2228313 /data/dalvik-cache/x86/system@app@PrintSpooler@PrintSpooler.apk@classes.dex
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-indirect ref table (deleted)
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-indirect ref table (deleted)
com.andro 19725 u0_a54 mem REG 8,1 4912800 262602 /system/lib/libart-compiler.so
com.andro 19725 u0_a54 mem REG 8,1 1232260 262969 /system/lib/libvixl.so
com.andro 19725 u0_a54 mem REG 8,1 22201456 263865 /system/usr/icu/icudt56l.dat
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-Jit thread pool worker thread 0 (deleted)
com.andro 19725 u0_a54 mem CHR 10,60 7622 /dev/binder
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)
com.andro 19725 u0_a54 mem REG 8,1 8774704 263011 /system/lib/libart.so
com.andro 19725 u0_a54 mem REG 8,1 29176 263435 /system/fonts/NotoSansLao-Bold.ttf
com.andro 19725 u0_a54 mem REG 8,1 411120 262703 /system/lib/libinputflinger.so
com.andro 19725 u0_a54 mem REG 8,1 42532 262665 /system/lib/libnativeloader.so
com.andro 19725 u0_a54 mem REG 8,1 30228 262758 /system/lib/libhardware_legacy.so
com.andro 19725 u0_a54 mem REG 8,1 46512 263059 /system/lib/libRS.so
"""
# Pure Pandas - probably not what you want:
print(pd.read_csv(StringIO(xaxa2), sep=r'\s+', on_bad_lines='skip').to_string())
com.blues 2003 system mem unknown /dev/ashmem/dalvik-LinearAlloc (deleted)
com.blues 2003 system mem CHR 10,60 7622 /dev/binder
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-main space (deleted)
com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-LinearAlloc (deleted) NaN
com.andro 19725 u0_a54 mem CHR 10,60 7622 /dev/binder
df2 = pd.Q_convert_to_df(string_table=xaxa2, regex_sep=r"\s+", tolerance=1)
print(df2.to_string())
0 1 6 8 11 25 27 31 32
0 com.blues 2003 system mem unknown /dev/ashmem/dalvik-LinearAlloc (deleted)
1 com.blues 2003 system mem CHR 10,60 7622 /dev/binder
2 com.blues 2003 system mem unknown /dev/ashmem/dalvik-indirect ref table (deleted)
3 com.blues 2003 system mem unknown /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)
4 com.blues 2003 system mem REG 8,1 8774704 263011 /system/lib/libart.so
5 com.blues 2003 system mem REG 8,1 29176 263435 /system/fonts/NotoSansLao-Bold.ttf
6 com.blues 2003 system mem REG 8,1 411120 262703 /system/lib/libinputflinger.so
7 com.andro 19725 u0_a54 cwd DIR 0,2 820 2 /
8 com.andro 19725 u0_a54 rtd DIR 0,2 820 2 /
9 com.andro 19725 u0_a54 txt REG 8,1 17948 262260 /system/bin/app_process32
10 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-main space (deleted)
11 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-main space 1 (deleted)
12 com.andro 19725 u0_a54 mem REG 8,17 2125824 2228227 /data/dalvik-cache/x86/system@framework@boot.art
13 com.andro 19725 u0_a54 mem REG 8,17 1167360 2228229 /data/dalvik-cache/x86/system@framework@boot-core-libart.art
14 com.andro 19725 u0_a54 mem REG 8,1 5142 263912 /system/usr/hyphen-data/hyph-mn-cyrl.hyb
15 com.andro 19725 u0_a54 mem REG 8,1 35913 263879 /system/usr/hyphen-data/hyph-cy.hyb
16 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
17 com.andro 19725 u0_a54 mem REG 8,1 67076 262937 /system/lib/libkeymaster_messages.so
18 com.andro 19725 u0_a54 mem REG 8,1 202252 262648 /system/lib/libkeymaster1.so
19 com.andro 19725 u0_a54 mem REG 8,1 160904 262967 /system/lib/libsoftkeymasterdevice.so
20 com.andro 19725 u0_a54 mem REG 8,1 156172 262657 /system/lib/libjavacrypto.so
21 com.andro 19725 u0_a54 mem REG 8,1 124456 263004 /system/lib/libkeystore_binder.so
22 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
23 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
24 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
25 com.andro 19725 u0_a54 mem REG 0,15 131072 6346 /dev/__properties__/u:object_r:logd_prop:s0
26 com.andro 19725 u0_a54 mem REG 0,15 131072 6339 /dev/__properties__/u:object_r:default_prop:s0
27 com.andro 19725 u0_a54 mem REG 8,1 8165 263886 /system/usr/hyphen-data/hyph-fr.hyb
28 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
29 com.andro 19725 u0_a54 mem REG 8,1 607 263890 /system/usr/hyphen-data/hyph-pa.hyb
30 com.andro 19725 u0_a54 mem REG 8,1 9716 262949 /system/lib/libkeystore-engine.so
31 com.andro 19725 u0_a54 mem REG 8,1 647 263924 /system/usr/hyphen-data/hyph-or.hyb
32 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
33 com.andro 19725 u0_a54 mem REG 8,1 518036 262595 /system/lib/libmedia_jni.so
34 com.andro 19725 u0_a54 mem REG 8,1 202168 263023 /system/lib/libexif.so
35 com.andro 19725 u0_a54 mem REG 8,1 136632 262593 /system/lib/libmtp.so
36 com.andro 19725 u0_a54 mem REG 8,1 71116 263050 /system/lib/libstagefright_amrnb_common.so
37 com.andro 19725 u0_a54 mem REG 8,1 687 263891 /system/usr/hyphen-data/hyph-mr.hyb
38 com.andro 19725 u0_a54 mem REG 0,15 131072 6352 /dev/__properties__/u:object_r:log_prop:s0
39 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
40 com.andro 19725 u0_a54 mem REG 8,1 504430 263754 /system/usr/share/zoneinfo/tzdata
41 com.andro 19725 u0_a54 mem REG 8,1 18677700 263362 /system/fonts/NotoSansCJK-Regular.ttc
42 com.andro 19725 u0_a54 mem REG 8,1 6967 263882 /system/usr/hyphen-data/hyph-da.hyb
43 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
44 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-large object space allocation (deleted)
45 com.andro 19725 u0_a54 mem REG 8,1 40308 263449 /system/fonts/CarroisGothicSC-Regular.ttf
46 com.andro 19725 u0_a54 mem REG 8,1 22201456 263865 /system/usr/icu/icudt56l.dat
47 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-LinearAlloc (deleted)
48 com.andro 19725 u0_a54 mem REG 8,17 1663816 2228313 /data/dalvik-cache/x86/system@app@PrintSpooler@PrintSpooler.apk@classes.dex
49 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-indirect ref table (deleted)
50 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-indirect ref table (deleted)
51 com.andro 19725 u0_a54 mem REG 8,1 4912800 262602 /system/lib/libart-compiler.so
52 com.andro 19725 u0_a54 mem REG 8,1 1232260 262969 /system/lib/libvixl.so
53 com.andro 19725 u0_a54 mem REG 8,1 22201456 263865 /system/usr/icu/icudt56l.dat
54 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-Jit thread pool worker thread 0 (deleted)
55 com.andro 19725 u0_a54 mem CHR 10,60 7622 /dev/binder
56 com.andro 19725 u0_a54 mem unknown /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)
57 com.andro 19725 u0_a54 mem REG 8,1 8774704 263011 /system/lib/libart.so
58 com.andro 19725 u0_a54 mem REG 8,1 29176 263435 /system/fonts/NotoSansLao-Bold.ttf
59 com.andro 19725 u0_a54 mem REG 8,1 411120 262703 /system/lib/libinputflinger.so
60 com.andro 19725 u0_a54 mem REG 8,1 42532 262665 /system/lib/libnativeloader.so
61 com.andro 19725 u0_a54 mem REG 8,1 30228 262758 /system/lib/libhardware_legacy.so
62 com.andro 19725 u0_a54 mem REG 8,1 46512 263059 /system/lib/libRS.so
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
a_pandas_ex_csv_plus-0.10.tar.gz
(10.8 kB
view hashes)
Built Distribution
Close
Hashes for a_pandas_ex_csv_plus-0.10.tar.gz
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 905e78ce6ea43fabc264fdd487d333e790dd98a2741c570be577a4407a8fc69d |
|
| MD5 | e252eba7e3a3113ee5f0be813c3806fe |
|
| BLAKE2b-256 | d949dbaada2555a0db3ab55a2ec56aad9bd2cd7719ab3bace1dd3899d258b5ae |
Close
Hashes for a_pandas_ex_csv_plus-0.10-py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | b52df13de7523dc29638c81ff92c221a8c41295645ec1b911ce3023c5de573ee |
|
| MD5 | 4ed0c2d829a6d53c06f84cba8e9f512e |
|
| BLAKE2b-256 | 108c706a2039b46e93e20144b06b90df3c24dc44373d677cdcbaae5048ff3e0d |
