Merge pull request #4 from ManishMadan2882/main #11
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Parse and Combine JSON Files into a Single JSON File and CSV | |
on: | |
push: | |
branches: [ main ] | |
paths-ignore: | |
- 'gpu-benchmarks.json' | |
- 'gpu-benchmarks.csv' | |
jobs: | |
parse_and_combine: | |
if: "!contains(github.event.head_commit.message, '[skip ci]')" | |
runs-on: ubuntu-latest | |
steps: | |
- name: Checkout code | |
uses: actions/checkout@v3 | |
with: | |
ssh-key: ${{ secrets.DEPLOY_KEY }} | |
- name: Install jq | |
run: sudo apt-get install -y jq | |
- name: Parsing and Combining JSON Files | |
run: | | |
git config --global user.email "[email protected]" | |
git config --global user.name "Alex" | |
# Find all JSON files in the benchmarks folder and its subfolders | |
json_files=$(find benchmarks -type f -name "*.json") | |
# Use jq to parse and combine the JSON files | |
jq -s '.' $json_files > gpu-benchmarks.json | |
# Convert JSON to CSV using jq | |
jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv' gpu-benchmarks.json > gpu-benchmarks.csv | |
git add gpu-benchmarks.json gpu-benchmarks.csv | |
git commit -m "Update gpu-benchmarks.json and gpu-benchmarks.csv [skip ci]" | |
git push origin main |