gfix
A command line tool to fix Excel-converted gene names in spreadsheets. Excel automatically converts some gene names (like MARCH1, SEPT2) to dates - this tool converts them back.
Features
- Fixes common gene-to-date conversions (MARCH1 → Mar-1 → MARCHF1)
- Processes all sheets in an Excel file
- Preserves original data format
- Detailed change logging
The list of genes that are modified can be found here: https://github.com/sbooeshaghi/gfix/blob/a854d9b8fc0643154d290a1dc2d534c5a9f823a5/gfix/main.py#L94
Installation
# devel
pip install git+https://github.com/sbooeshaghi/gfix.git
# pypi
pip install gfix
Usage
gfix -o output.xlsx input.xlsx
Example
If your Excel file has converted gene names to dates (e.g., MARCH1 appears as "Mar-1" or "3/1/2024"), running gfix will restore the correct gene symbols:
$ gfix -o fixed_data.xlsx raw_data.xlsx
Processing raw_data.xlsx...
Processing sheet: Sheet1
Changes in sheet 'Sheet1':
Location: Row 5, Column 0
Old value: 3/1/2024
New value: MARCHF1
...
1 maintainer
Release files for gfix 0.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| gfix-0.0.0.tar.gz | 5.0 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| gfix-0.0.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 9.9 kB
Release files / gfix-0.0.0.tar.gz
| Download URL | gfix-0.0.0.tar.gz |
|---|---|
| Size | 5.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
5d69386906a8db44628d002a5095943a64da6c1d5a63f80b67b019b2ba6d9827
|
|
BLAKE2b-256 checksum How to use checksums |
da28e6065120728882b499743a713643c09278463d18ee16127fd1032704d757
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.1 CPython/3.9.5
|
Release files / gfix-0.0.0-py3-none-any.whl
| Download URL | gfix-0.0.0-py3-none-any.whl |
|---|---|
| Size | 4.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
b2405956a06b6bd18e0187963cef0e8334956093d38090f9d6a8cf4b221bfc86
|
|
BLAKE2b-256 checksum How to use checksums |
6adfb7de0462125721ee436e518ab91bbf671874cf39b270e9ec35d6dea67d75
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.1 CPython/3.9.5
|
