flysight2csv 0.1.1

Utilities for finding and reformatting FlySight 2 CSV files (SENSOR.CSV and TRACK.CSV).

FlySight2CSV

---

Source Code: https://github.com/yoleg/flysight2csv

---

Utilities for finding and reformatting FlySight 2 CSV files (SENSOR.CSV and TRACK.CSV).

:bulb: This is an early release. Please let me know how you use this tool and what features you would like to see.

Features

The flysight2csv command does one or more of the following:

• Find all the FlySight 2 CSV files in one or more directories.
• Copy the files to a new directory, optionally prepending the parent directory names to the filename.
• Reformat the CSV files for easier use with other tools, such as Pandas dataframes.
  • Available formats:
    • Flat CSV (single header row)
    • JSON lines (one JSON object per line)
    • Original (unchanged)
  • Added metadata fields:
    • Original filename
    • Original line number
    • Date/time in ISO format
    • Sensor type
  • Additional options:
    • Select only the columns you need
    • Select only the sensors you need

Possible future features

Let me know if you would like to see any of these added.

• Merge the SENSOR.CSV and TRACK.CSV files into a single CSV file.
• Trim the CSV files to just the descent or ascent portion of a flight.
• Filter the CSV files by date/time, altitude, or other criteria.
• Add units to the CSV files.
• Add a header row to the minimal JSONL file with all fields set to null.
• Show a summary of date ranges and altitudes from the discovered CSV files.
• Installers for Windows, Mac, and Linux.
• Simple graphical user interface (GUI) for selecting options and running the command.

Installation

First, make sure you have Python 3.10 or later installed. You can check this by running:

python --version

If needed, you can download the latest version of Python from python.org.

Then, install flysight2csv via pip (or your favourite Python package manager):

pip install flysight2csv

:bulb: TIP: Consider using pipx or a virtual environment to avoid installing packages globally.

Once that completes, reopen your terminal and run flysight2csv --help to confirm it is installed correctly.

:bulb: Additional help with pip is available at the pip documentation.

Usage

Please note that this is an early release, and the API may change in future versions.

By default, the command simply lists out all the CSV files it finds with a valid FlySight 2 format:

flysight2csv paths/to/files.csv /or/directories/

Copy the files to a new directory, prepending the date and time to the filename:

flysight2csv source/paths/ -o output/path/

Reformat the copied files into a "flat" CSV (single header) for use with other tools:

flysight2csv source/paths/ -o output/path/ -f csv-flat

For more options, see the help:

flysight2csv --help

Troubleshooting

Command not found

If the flysight2csv command is not available after you have installed it, make sure you have installed it in the same Python environment you are using to run the command. For example, if you have both Python 3.12 and Python 3.10 installed, you may need to run pip3.12 install flysight2csv or py -3.12 -m pip install flysight2csv to install it for Python 3.12.

You can also try running python -m flysight2csv instead of flysight2csv.

Finally, if you are using a virtual environment, make sure you have activated it before running the command.

Contributors ✨

Contributions of any kind welcome! Please see the contributing guide.

Credits

This package was created with Copier and the browniebroke/pypackage-template project template.