a-pandas-ex-csv-plus


Namea-pandas-ex-csv-plus JSON
Version 0.10 PyPI version JSON
download
home_pagehttps://github.com/hansalemaos/a_pandas_ex_csv_plus
SummaryWhen pd.read_csv(csvstring, sep=r'\s+') doesn't work ...
upload_time2022-12-07 05:48:10
maintainer
docs_urlNone
authorJohannes Fischer
requires_python
licenseMIT
keywords csv pandas dataframe read
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            
# When pd.read_csv(csvstring, sep='\s+') doesn't work ... 



```python

pip install a-pandas-ex-csv-plus

```



```python

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





```


            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/hansalemaos/a_pandas_ex_csv_plus",
    "name": "a-pandas-ex-csv-plus",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "csv,pandas,DataFrame,read",
    "author": "Johannes Fischer",
    "author_email": "<aulasparticularesdealemaosp@gmail.com>",
    "download_url": "https://files.pythonhosted.org/packages/d9/49/dbaada2555a0db3ab55a2ec56aad9bd2cd7719ab3bace1dd3899d258b5ae/a_pandas_ex_csv_plus-0.10.tar.gz",
    "platform": null,
    "description": "\n# When pd.read_csv(csvstring, sep='\\s+') doesn't work ... \n\n\n\n```python\n\npip install a-pandas-ex-csv-plus\n\n```\n\n\n\n```python\n\nfrom a_pandas_ex_csv_plus import pd_add_convert_to_df\n\npd_add_convert_to_df()\n\nimport pandas as pd\n\nxaxa='''\n\n2020-09-1022-30-03.mp4   2020-10-08 18-54-44.mp4   2020-10-14 19-46-34.mp4\n\n2020-09-1022-30-10.mp4   2020-10-08 18-56-39.mp4   2020-10-17 12-11-54.mp4\n\n2020-09-1022-30-13.mp4                            2020-10-17 13-23-56.mp4\n\n2020-09-1022-30-33.mp4                           \n\n2020-09-1022-30-38.mp4                           \n\n2020-09-1022-30-41.mp4                            2020-10-17 13-30-27.mp4\n\n2020-09-1022-31-03.mp4   2020-10-1115-49-19.mp4   2020-10-17 13-30-28.mp4\n\n2020-09-1022-31-36.mp4   2020-10-1116-10-45.mp4   2020-10-17 13-30-41.mp4\n\n                        2020-10-11 16-34-20.mp4   acesseoscursos.mp4\n\n                        2020-10-1116-48-08.mp4    acesseoscursoscelular.mp4\n\n                        2020-10-11 19-00-47.mp4    reaberturatrailer.mp4\n\n                        2020-10-1119-08-19.mp4   rexmega.mp4\n\n2020-10-0818-54-37.mp4  2020-10-1119-17-33.mp4\n\n'''\n\n## Pure Pandas - probably not what you want:\n\n\n\nprint(pd.read_csv(StringIO(xaxa), sep=r'\\s+', on_bad_lines='skip').to_string())\n\n    2020-09-1022-30-03.mp4                 2020-10-08           18-54-44.mp4    2020-10-14  19-46-34.mp4\n\n0   2020-09-1022-30-10.mp4                 2020-10-08           18-56-39.mp4    2020-10-17  12-11-54.mp4\n\n1   2020-09-1022-30-13.mp4                 2020-10-17           13-23-56.mp4           NaN           NaN\n\n2   2020-09-1022-30-33.mp4                        NaN                    NaN           NaN           NaN\n\n3   2020-09-1022-30-38.mp4                        NaN                    NaN           NaN           NaN\n\n4   2020-09-1022-30-41.mp4                 2020-10-17           13-30-27.mp4           NaN           NaN\n\n5   2020-09-1022-31-03.mp4     2020-10-1115-49-19.mp4             2020-10-17  13-30-28.mp4           NaN\n\n6   2020-09-1022-31-36.mp4     2020-10-1116-10-45.mp4             2020-10-17  13-30-41.mp4           NaN\n\n7               2020-10-11               16-34-20.mp4     acesseoscursos.mp4           NaN           NaN\n\n8   2020-10-1116-48-08.mp4  acesseoscursoscelular.mp4                    NaN           NaN           NaN\n\n9               2020-10-11               19-00-47.mp4  reaberturatrailer.mp4           NaN           NaN\n\n10  2020-10-1119-08-19.mp4                rexmega.mp4                    NaN           NaN           NaN\n\n11  2020-10-0818-54-37.mp4     2020-10-1119-17-33.mp4                    NaN           NaN           NaN\n\n\n\ndf = pd.Q_convert_to_df(string_table=xaxa, regex_sep=r\"\\s+\", tolerance=1)\n\nprint(df.to_string())\n\n                         0                        2                          3\n\n0   2020-09-1022-30-03.mp4  2020-10-08 18-54-44.mp4    2020-10-14 19-46-34.mp4\n\n1   2020-09-1022-30-10.mp4  2020-10-08 18-56-39.mp4    2020-10-17 12-11-54.mp4\n\n2   2020-09-1022-30-13.mp4                             2020-10-17 13-23-56.mp4\n\n3   2020-09-1022-30-33.mp4                                                    \n\n4   2020-09-1022-30-38.mp4                                                    \n\n5   2020-09-1022-30-41.mp4                             2020-10-17 13-30-27.mp4\n\n6   2020-09-1022-31-03.mp4   2020-10-1115-49-19.mp4    2020-10-17 13-30-28.mp4\n\n7   2020-09-1022-31-36.mp4   2020-10-1116-10-45.mp4    2020-10-17 13-30-41.mp4\n\n8                           2020-10-11 16-34-20.mp4         acesseoscursos.mp4\n\n9                            2020-10-1116-48-08.mp4  acesseoscursoscelular.mp4\n\n10                          2020-10-11 19-00-47.mp4      reaberturatrailer.mp4\n\n11                           2020-10-1119-08-19.mp4                rexmega.mp4\n\n12  2020-10-0818-54-37.mp4   2020-10-1119-17-33.mp4                           \n\n\n\n\n\nxaxa2 = \"\"\"\n\ncom.blues  2003     system  mem   unknown                                         /dev/ashmem/dalvik-LinearAlloc (deleted)\n\ncom.blues  2003     system  mem       CHR              10,60                 7622 /dev/binder\n\ncom.blues  2003     system  mem   unknown                                         /dev/ashmem/dalvik-indirect ref table (deleted)\n\ncom.blues  2003     system  mem   unknown                                         /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)\n\ncom.blues  2003     system  mem       REG                8,1   8774704     263011 /system/lib/libart.so\n\ncom.blues  2003     system  mem       REG                8,1     29176     263435 /system/fonts/NotoSansLao-Bold.ttf\n\ncom.blues  2003     system  mem       REG                8,1    411120     262703 /system/lib/libinputflinger.so\n\ncom.andro 19725     u0_a54  cwd       DIR                0,2       820          2 /\n\ncom.andro 19725     u0_a54  rtd       DIR                0,2       820          2 /\n\ncom.andro 19725     u0_a54  txt       REG                8,1     17948     262260 /system/bin/app_process32\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-main space (deleted)\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-main space 1 (deleted)\n\ncom.andro 19725     u0_a54  mem       REG               8,17   2125824    2228227 /data/dalvik-cache/x86/system@framework@boot.art\n\ncom.andro 19725     u0_a54  mem       REG               8,17   1167360    2228229 /data/dalvik-cache/x86/system@framework@boot-core-libart.art\n\ncom.andro 19725     u0_a54  mem       REG                8,1      5142     263912 /system/usr/hyphen-data/hyph-mn-cyrl.hyb\n\ncom.andro 19725     u0_a54  mem       REG                8,1     35913     263879 /system/usr/hyphen-data/hyph-cy.hyb\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem       REG                8,1     67076     262937 /system/lib/libkeymaster_messages.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1    202252     262648 /system/lib/libkeymaster1.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1    160904     262967 /system/lib/libsoftkeymasterdevice.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1    156172     262657 /system/lib/libjavacrypto.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1    124456     263004 /system/lib/libkeystore_binder.so\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem       REG               0,15    131072       6346 /dev/__properties__/u:object_r:logd_prop:s0\n\ncom.andro 19725     u0_a54  mem       REG               0,15    131072       6339 /dev/__properties__/u:object_r:default_prop:s0\n\ncom.andro 19725     u0_a54  mem       REG                8,1      8165     263886 /system/usr/hyphen-data/hyph-fr.hyb\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem       REG                8,1       607     263890 /system/usr/hyphen-data/hyph-pa.hyb\n\ncom.andro 19725     u0_a54  mem       REG                8,1      9716     262949 /system/lib/libkeystore-engine.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1       647     263924 /system/usr/hyphen-data/hyph-or.hyb\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem       REG                8,1    518036     262595 /system/lib/libmedia_jni.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1    202168     263023 /system/lib/libexif.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1    136632     262593 /system/lib/libmtp.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1     71116     263050 /system/lib/libstagefright_amrnb_common.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1       687     263891 /system/usr/hyphen-data/hyph-mr.hyb\n\ncom.andro 19725     u0_a54  mem       REG               0,15    131072       6352 /dev/__properties__/u:object_r:log_prop:s0\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem       REG                8,1    504430     263754 /system/usr/share/zoneinfo/tzdata\n\ncom.andro 19725     u0_a54  mem       REG                8,1  18677700     263362 /system/fonts/NotoSansCJK-Regular.ttc\n\ncom.andro 19725     u0_a54  mem       REG                8,1      6967     263882 /system/usr/hyphen-data/hyph-da.hyb\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-large object space allocation (deleted)\n\ncom.andro 19725     u0_a54  mem       REG                8,1     40308     263449 /system/fonts/CarroisGothicSC-Regular.ttf\n\ncom.andro 19725     u0_a54  mem       REG                8,1  22201456     263865 /system/usr/icu/icudt56l.dat\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-LinearAlloc (deleted)\n\ncom.andro 19725     u0_a54  mem       REG               8,17   1663816    2228313 /data/dalvik-cache/x86/system@app@PrintSpooler@PrintSpooler.apk@classes.dex\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-indirect ref table (deleted)\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-indirect ref table (deleted)\n\ncom.andro 19725     u0_a54  mem       REG                8,1   4912800     262602 /system/lib/libart-compiler.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1   1232260     262969 /system/lib/libvixl.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1  22201456     263865 /system/usr/icu/icudt56l.dat\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-Jit thread pool worker thread 0 (deleted)\n\ncom.andro 19725     u0_a54  mem       CHR              10,60                 7622 /dev/binder\n\ncom.andro 19725     u0_a54  mem   unknown                                         /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)\n\ncom.andro 19725     u0_a54  mem       REG                8,1   8774704     263011 /system/lib/libart.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1     29176     263435 /system/fonts/NotoSansLao-Bold.ttf\n\ncom.andro 19725     u0_a54  mem       REG                8,1    411120     262703 /system/lib/libinputflinger.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1     42532     262665 /system/lib/libnativeloader.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1     30228     262758 /system/lib/libhardware_legacy.so\n\ncom.andro 19725     u0_a54  mem       REG                8,1     46512     263059 /system/lib/libRS.so\n\n\"\"\"\n\n\n\n# Pure Pandas - probably not what you want:\n\n\n\nprint(pd.read_csv(StringIO(xaxa2), sep=r'\\s+', on_bad_lines='skip').to_string())\n\n           com.blues    2003 system      mem                         unknown /dev/ashmem/dalvik-LinearAlloc    (deleted)\n\ncom.blues       2003  system    mem      CHR                           10,60                           7622  /dev/binder\n\ncom.andro      19725  u0_a54    mem  unknown         /dev/ashmem/dalvik-main                          space    (deleted)\n\ncom.andro      19725  u0_a54    mem  unknown  /dev/ashmem/dalvik-LinearAlloc                      (deleted)          NaN\n\ncom.andro      19725  u0_a54    mem      CHR                           10,60                           7622  /dev/binder\n\n\n\n\n\ndf2 = pd.Q_convert_to_df(string_table=xaxa2, regex_sep=r\"\\s+\", tolerance=1)\n\nprint(df2.to_string())\n\n\n\n           0      1       6    8        11     25        27       31                                                                               32\n\n0   com.blues   2003  system  mem  unknown                                                                   /dev/ashmem/dalvik-LinearAlloc (deleted)\n\n1   com.blues   2003  system  mem      CHR  10,60               7622                                                                      /dev/binder\n\n2   com.blues   2003  system  mem  unknown                                                            /dev/ashmem/dalvik-indirect ref table (deleted)\n\n3   com.blues   2003  system  mem  unknown                            /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)\n\n4   com.blues   2003  system  mem      REG    8,1   8774704   263011                                                            /system/lib/libart.so\n\n5   com.blues   2003  system  mem      REG    8,1     29176   263435                                               /system/fonts/NotoSansLao-Bold.ttf\n\n6   com.blues   2003  system  mem      REG    8,1    411120   262703                                                   /system/lib/libinputflinger.so\n\n7   com.andro  19725  u0_a54  cwd      DIR    0,2       820        2                                                                                /\n\n8   com.andro  19725  u0_a54  rtd      DIR    0,2       820        2                                                                                /\n\n9   com.andro  19725  u0_a54  txt      REG    8,1     17948   262260                                                        /system/bin/app_process32\n\n10  com.andro  19725  u0_a54  mem  unknown                                                                    /dev/ashmem/dalvik-main space (deleted)\n\n11  com.andro  19725  u0_a54  mem  unknown                                                                  /dev/ashmem/dalvik-main space 1 (deleted)\n\n12  com.andro  19725  u0_a54  mem      REG   8,17   2125824  2228227                                 /data/dalvik-cache/x86/system@framework@boot.art\n\n13  com.andro  19725  u0_a54  mem      REG   8,17   1167360  2228229                     /data/dalvik-cache/x86/system@framework@boot-core-libart.art\n\n14  com.andro  19725  u0_a54  mem      REG    8,1      5142   263912                                         /system/usr/hyphen-data/hyph-mn-cyrl.hyb\n\n15  com.andro  19725  u0_a54  mem      REG    8,1     35913   263879                                              /system/usr/hyphen-data/hyph-cy.hyb\n\n16  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n17  com.andro  19725  u0_a54  mem      REG    8,1     67076   262937                                             /system/lib/libkeymaster_messages.so\n\n18  com.andro  19725  u0_a54  mem      REG    8,1    202252   262648                                                     /system/lib/libkeymaster1.so\n\n19  com.andro  19725  u0_a54  mem      REG    8,1    160904   262967                                            /system/lib/libsoftkeymasterdevice.so\n\n20  com.andro  19725  u0_a54  mem      REG    8,1    156172   262657                                                     /system/lib/libjavacrypto.so\n\n21  com.andro  19725  u0_a54  mem      REG    8,1    124456   263004                                                /system/lib/libkeystore_binder.so\n\n22  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n23  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n24  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n25  com.andro  19725  u0_a54  mem      REG   0,15    131072     6346                                      /dev/__properties__/u:object_r:logd_prop:s0\n\n26  com.andro  19725  u0_a54  mem      REG   0,15    131072     6339                                   /dev/__properties__/u:object_r:default_prop:s0\n\n27  com.andro  19725  u0_a54  mem      REG    8,1      8165   263886                                              /system/usr/hyphen-data/hyph-fr.hyb\n\n28  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n29  com.andro  19725  u0_a54  mem      REG    8,1       607   263890                                              /system/usr/hyphen-data/hyph-pa.hyb\n\n30  com.andro  19725  u0_a54  mem      REG    8,1      9716   262949                                                /system/lib/libkeystore-engine.so\n\n31  com.andro  19725  u0_a54  mem      REG    8,1       647   263924                                              /system/usr/hyphen-data/hyph-or.hyb\n\n32  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n33  com.andro  19725  u0_a54  mem      REG    8,1    518036   262595                                                      /system/lib/libmedia_jni.so\n\n34  com.andro  19725  u0_a54  mem      REG    8,1    202168   263023                                                           /system/lib/libexif.so\n\n35  com.andro  19725  u0_a54  mem      REG    8,1    136632   262593                                                            /system/lib/libmtp.so\n\n36  com.andro  19725  u0_a54  mem      REG    8,1     71116   263050                                       /system/lib/libstagefright_amrnb_common.so\n\n37  com.andro  19725  u0_a54  mem      REG    8,1       687   263891                                              /system/usr/hyphen-data/hyph-mr.hyb\n\n38  com.andro  19725  u0_a54  mem      REG   0,15    131072     6352                                       /dev/__properties__/u:object_r:log_prop:s0\n\n39  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n40  com.andro  19725  u0_a54  mem      REG    8,1    504430   263754                                                /system/usr/share/zoneinfo/tzdata\n\n41  com.andro  19725  u0_a54  mem      REG    8,1  18677700   263362                                            /system/fonts/NotoSansCJK-Regular.ttc\n\n42  com.andro  19725  u0_a54  mem      REG    8,1      6967   263882                                              /system/usr/hyphen-data/hyph-da.hyb\n\n43  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n44  com.andro  19725  u0_a54  mem  unknown                                                 /dev/ashmem/dalvik-large object space allocation (deleted)\n\n45  com.andro  19725  u0_a54  mem      REG    8,1     40308   263449                                        /system/fonts/CarroisGothicSC-Regular.ttf\n\n46  com.andro  19725  u0_a54  mem      REG    8,1  22201456   263865                                                     /system/usr/icu/icudt56l.dat\n\n47  com.andro  19725  u0_a54  mem  unknown                                                                   /dev/ashmem/dalvik-LinearAlloc (deleted)\n\n48  com.andro  19725  u0_a54  mem      REG   8,17   1663816  2228313      /data/dalvik-cache/x86/system@app@PrintSpooler@PrintSpooler.apk@classes.dex\n\n49  com.andro  19725  u0_a54  mem  unknown                                                            /dev/ashmem/dalvik-indirect ref table (deleted)\n\n50  com.andro  19725  u0_a54  mem  unknown                                                            /dev/ashmem/dalvik-indirect ref table (deleted)\n\n51  com.andro  19725  u0_a54  mem      REG    8,1   4912800   262602                                                   /system/lib/libart-compiler.so\n\n52  com.andro  19725  u0_a54  mem      REG    8,1   1232260   262969                                                           /system/lib/libvixl.so\n\n53  com.andro  19725  u0_a54  mem      REG    8,1  22201456   263865                                                     /system/usr/icu/icudt56l.dat\n\n54  com.andro  19725  u0_a54  mem  unknown                                               /dev/ashmem/dalvik-Jit thread pool worker thread 0 (deleted)\n\n55  com.andro  19725  u0_a54  mem      CHR  10,60               7622                                                                      /dev/binder\n\n56  com.andro  19725  u0_a54  mem  unknown                            /dev/ashmem/dalvik-allocspace zygote / non moving space live-bitmap 0 (deleted)\n\n57  com.andro  19725  u0_a54  mem      REG    8,1   8774704   263011                                                            /system/lib/libart.so\n\n58  com.andro  19725  u0_a54  mem      REG    8,1     29176   263435                                               /system/fonts/NotoSansLao-Bold.ttf\n\n59  com.andro  19725  u0_a54  mem      REG    8,1    411120   262703                                                   /system/lib/libinputflinger.so\n\n60  com.andro  19725  u0_a54  mem      REG    8,1     42532   262665                                                   /system/lib/libnativeloader.so\n\n61  com.andro  19725  u0_a54  mem      REG    8,1     30228   262758                                                /system/lib/libhardware_legacy.so\n\n62  com.andro  19725  u0_a54  mem      REG    8,1     46512   263059                                                             /system/lib/libRS.so\n\n\n\n\n\n```\n\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "When pd.read_csv(csvstring, sep=r'\\s+') doesn't work ...",
    "version": "0.10",
    "split_keywords": [
        "csv",
        "pandas",
        "dataframe",
        "read"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "108c706a2039b46e93e20144b06b90df3c24dc44373d677cdcbaae5048ff3e0d",
                "md5": "4ed0c2d829a6d53c06f84cba8e9f512e",
                "sha256": "b52df13de7523dc29638c81ff92c221a8c41295645ec1b911ce3023c5de573ee"
            },
            "downloads": -1,
            "filename": "a_pandas_ex_csv_plus-0.10-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "4ed0c2d829a6d53c06f84cba8e9f512e",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 10644,
            "upload_time": "2022-12-07T05:48:08",
            "upload_time_iso_8601": "2022-12-07T05:48:08.291678Z",
            "url": "https://files.pythonhosted.org/packages/10/8c/706a2039b46e93e20144b06b90df3c24dc44373d677cdcbaae5048ff3e0d/a_pandas_ex_csv_plus-0.10-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "d949dbaada2555a0db3ab55a2ec56aad9bd2cd7719ab3bace1dd3899d258b5ae",
                "md5": "e252eba7e3a3113ee5f0be813c3806fe",
                "sha256": "905e78ce6ea43fabc264fdd487d333e790dd98a2741c570be577a4407a8fc69d"
            },
            "downloads": -1,
            "filename": "a_pandas_ex_csv_plus-0.10.tar.gz",
            "has_sig": false,
            "md5_digest": "e252eba7e3a3113ee5f0be813c3806fe",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 10843,
            "upload_time": "2022-12-07T05:48:10",
            "upload_time_iso_8601": "2022-12-07T05:48:10.398828Z",
            "url": "https://files.pythonhosted.org/packages/d9/49/dbaada2555a0db3ab55a2ec56aad9bd2cd7719ab3bace1dd3899d258b5ae/a_pandas_ex_csv_plus-0.10.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2022-12-07 05:48:10",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "github_user": "hansalemaos",
    "github_project": "a_pandas_ex_csv_plus",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": false,
    "requirements": [],
    "lcname": "a-pandas-ex-csv-plus"
}
        
Elapsed time: 0.04465s