Skip to main content

pyopen

pyopen is a command-line tool for quickly inspecting files using python. It drops you into an interactive IPython session with the parsed files available as local variables.

Currently supports csv/tsv files (uses pandas and also supports gzip / bz2 compression), excel, json, yaml, hdf5, and pickle files.

Installation

pip install pyopen

To run the tests:

nosetests

Example

$ pyopen test/data/data1.csv

f1 test/data/data1.csv 4.9 kB pandas_csv

Python 2.7.10 (default, May 26 2015, 13:01:57)
Type "copyright", "credits" or "license" for more information.

IPython 4.0.0 -- An enhanced Interactive Python.
?         -> Introduction and overview of IPython's features.
%quickref -> Quick reference.
help      -> Python's own help system.
object?   -> Details about 'object', use 'object??' for extra details.
1 files loaded:

f1 test/data/data1.csv 4.9 kB pandas_csv
    pandas.DataFrame: 99 rows x 8 cols.
    Columns: patient genome contig interbase_start interbase_end ref alt validation

Variables defined:
    f1 : the parsed file
    loaded : object with attributes for each parsed file (abbreviated filenames, tab completes)
    loaded_filenames : dict from filename to parsed file
    loaded_absolute_filenames : dict from absolute filename to parsed file
    loaded_list : list of the parsed files

To print this message again later, type 'info()'. To quit type 'quit()'.

The variable ‘f1’ is a pandas DataFrame with the contents of the csv file:

In [1]: f1.head()
Out[1]:
  patient  genome contig  interbase_start  interbase_end ref alt validation
0     PT1  GRCh37   chr1         10719783       10719784   T   G   untested
1     PT1  GRCh37   chr1         11137693       11137694   G   A   verified
2     PT1  GRCh37   chr1         11826130       11826131   A   T   verified
3     PT1  GRCh37   chr1         17664605       17664606   C   G   verified
4     PT1  GRCh37   chr1         26670492       26670493   G   T   verified

You can also pass URLs to pyopen:

$ pyopen https://github.com/timodonnell/pyopen/raw/master/test/data/nasa_19950801.tsv.bz2
...
In [1]: f1.mean()

Out[1]:
time         8.072857e+08
response     2.107552e+02
bytes        1.556397e+04
referer               NaN
useragent             NaN
dtype: float64
Out[1]: (30969, 9)

Metadata

Release files for pyopen 0.0.7

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pyopen 0.0.7
File Size Uploaded Provenance Actions
pyopen-0.0.7.tar.gz 7.1 kB Without provenance Details for pyopen-0.0.7.tar.gz

Release files / pyopen-0.0.7.tar.gz

Download URL pyopen-0.0.7.tar.gz
Size 7.1 kB
Tags Source
SHA-256 checksum
How to use checksums
2c88c400df6fad6c3575a6507059096bceee87bb2361c579d65f206436c843b1
BLAKE2b-256 checksum
How to use checksums
7884b9bcafe3b033897fcbdedb0b81f91090629258e103b46f5f94dc954cb6c0
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Security for pyopen 0.0.7

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page