Security News
tea.xyz Spam Plagues npm and RubyGems Package Registries
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
Readme
.. image:: https://img.shields.io/pypi/v/jsoncsv.svg :target: https://pypi.python.org/pypi/jsoncsv
.. image:: https://api.travis-ci.org/alingse/jsoncsv.svg?branch=master
.. image:: https://coveralls.io/repos/github/alingse/jsoncsv/badge.svg :target: https://coveralls.io/github/alingse/jsoncsv
jsoncsv (with mkexcel
) is a command tool to convert json file to csv/xlsx file.
It's simple, and no need user to specify the keys.
Just use them.
cat the raw.json to csv/xls use command line tool
.. code-block:: bash
cat raw.json | jsoncsv | mkexcel > output.csv
cat raw.json | jsoncsv | mkexcel -t xls > output.xls
make sure each line of raw json text file is a json object
.. code-block:: bash
$cat raw.json
{"id":1, "name":"A", "year": 2015}
{"id":2, "name":"S", "zone": "china"}
$cat raw.json | jsoncsv | mkexcel > output.csv
$cat output.csv
id,name,year,zone
1,A,2015,
2,S,,china
This is easily and needn't care the different keys from any two object.
if input file is an json_array, use -A/--array
to decode it
.. code-block:: bash
$cat raw.json
[{"id":1, "name":"A", "year": 2015}, {"id":2, "name":"S", "zone": "china"}]
$cat raw.json | jsoncsv -A | mkexcel > output.csv
$cat output.csv
id,name,year,zone
1,A,2015,
2,S,,china
another way to convert file step by step
.. code-block:: bash
$jsoncsv raw.json expand.json
$mkexcel expand.json -t xls output.xls
get more options with --help
.
.. code-block:: bash
jsoncsv --help
mkexcel --help
.. code-block:: bash
pip install jsoncsv
see #QuickStart and get more options with --help
.
just expand/restore the json, the expand json is one layer json.
.. code-block:: bash
jsoncsv raw.json expand.json
jsoncsv -r expand.json raw.json
cat raw.json | jsoncsv | jsoncsv -r > raw2.json
mkexcel the expanded json (one layer)
.. code-block:: bash
mkexcel expand.json output.csv
mkexcel -t xls expand.json > output.xls
mkexcel -t csv expand.json > output.csv
expand json, 展开 json
.. code-block:: bash
$jsoncsv -e raw.json expand.json
$cat raw.json expand.json
{"s":[1,2,{"w":1}]}
{"s.2.w": 1,"s.0": 1,"s.1": 2}
{"s":[1,2,{"w":1}]} will transformed to {"s.2.w": 1,"s.0": 1,"s.1": 2}
the output "expand.json" is only one layer json, it can be easy change to csv or xlsx (with mkexcel
)
restore the expanded json 重构被展开的json
.. code-block:: bash
jsoncsv -r expand.json raw.json
cat expand.json raw.json
{"s.2.w": 1,"s.0": 1,"s.1": 2}
{"s": [1, 2, {"w": 1}]}
{"s.2.w": 1,"s.0": 1,"s.1": 2} change to {"s":[1,2,{"w":1}]}
separator used for combine the keys in the tree
default separator is .
on safe mode, use escape separator to avoid confilct
expand:
['aa', 'bb', 'www.xxx.com'] --> 'aa\.bb\.www.xxx.com'
restore:
'aa\.bb\.www.xxx.com' --> ['aa', 'bb', 'www.xxx.com']
mkexcel
dump expanded (by jsoncsv) json file to csv or xls file
.. code-block:: bash
mkexcel expand.json output.csv
chose dump type in ['csv', 'xls'] default is 'csv'
.. code-block:: bash
cat expand.json|mkexcel -t csv > output.csv
cat expand.json|mkexcel -t xls > output.xls
NOTE/TODO
example:
.. code-block:: bash
echo '{"0":1,"1":[1,2]}'|jsoncsv -e| jsoncsv -r
[1, [1, 2]]
wait next next version
but better than python strand library csv.
see https://github.com/alingse/jsoncsv/issues/37
try use https://jsoncsv.jsonutil.online/ instead
FAQs
A command tool easily convert json file to csv or xlsx.
We found that jsoncsv demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
Security News
As cyber threats become more autonomous, AI-powered defenses are crucial for businesses to stay ahead of attackers who can exploit software vulnerabilities at scale.
Security News
UnitedHealth Group disclosed that the ransomware attack on Change Healthcare compromised protected health information for millions in the U.S., with estimated costs to the company expected to reach $1 billion.