The project aims to help data scientists to analyser parquet files using the most commons functions provided by pandas framework.
Below is the overview of the available functions:
$ parq-analyser -h
usage: parq-analyser [-h] [-P --path] [-H --head] [-T --tail] [-D --drop] [-SC SC [SC ...]] [-C] [-verbose] [-v]
Process parquet file data
optional arguments:
-h, --help show this help message and exit
-P --path the path of parquet file
-H --head the numbers of the first rows to be returned. The default value is 5 and the maximum accepted is 199 and
this is the default operation selected by program if no one is provided.
-T --tail the numbers of the last rows to be returned. The maximum number accepted is 199
-D --drop the numbers of the first rows to be dropped. The maximum number accepted is 199
-SC SC [SC ...] List of selected columns to be returned separated by space
-C Get total rows
-verbose enable verbose mode
-v shows the app version
Enjoy the program!
To run and install the app you must have the following specifications:
python >= 3.2
pip >= 20.1.1
pandas==1.0.5
tabulate==0.8.7
pyarrow
First of all you need to download a stable releases of the standalone parq-analyser binaries here. After that you have two options to install:
To install it you must use the following command.
pip install parse_parquet-X.X.X-py3-none-any.whl
Check if no error happens in the terminal and move to the next section.
To do it you must type the command pip install --editable . that will install it on your env python dependencies in developer mode.
Ps: This approach will remove the parq-analyser from the path after it is closed.
After install it you can type parq-analyser -h to get all information about the program.
Type the command parq-analyser -P test.paquet -H 3 to get the first N rows of parquet.
+----+---------+--------+
| | Names | Ages |
|----+---------+--------|
| 0 | Thiago | 34 |
| 1 | Lopes | 33 |
| 2 | Silva | 32 |
+----+---------+--------+
Ps: The maximum value accepted is 199
Type the command parq-analyser -P test.paquet -P 1 to get the last N rows of parquet.
+----+---------+--------+
| | Names | Ages |
|----+---------+--------|
| 2 | Silva | 32 |
+----+---------+--------+
Ps: The maximum value accepted is 199
You can combine this command getting the first or last rows. In order to exemplify you can run the command
parq-analyser -D 1 -P test.paquet -T 2 to drop the first rows and get the next ones.
+----+---------+--------+
| | Names | Ages |
|----+---------+--------|
| 1 | Lopes | 33 |
| 2 | Silva | 32 |
+----+---------+--------+
Ps: The maximum value accepted is 199
Type the command parq-analyser -P test.paquet -C to get the total rows of parquet file.
Total Rows: 2
Type the command parq-analyser -P test.paquet -SC Names to get the selected rows of parquet file.
Ps: You can mix this command with another ones.
+----+---------+
| | Names |
|----+---------|
| 0 | Thiago |
| 1 | Lopes |
| 2 | Silva |
+----+---------+
This section is related to the features/bug fixes of project.
I'd love if you contribute with the upcoming features or bug fixes. Go ahead and read the CONTRIBUTING file.
You can check it out for new features on github.
Follow me
Copyright (c) 2020 Thiago Lopes da Silva
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.