Interactive Column Mapping Tool (ICMT)

Live App

Project Overview

The Interactive Column Mapping Tool is a Streamlit application designed to allow users to upload Excel or CSV files, map their columns interactively to desired column names, and then download the processed data as a zipped Excel file. It aims to simplify and streamline the process of data wrangling for datasets with varying column names.

Live App

You can access and use the live app here.

Installation & Setup

1. Ensure you have Python installed. This project requires Python 3.7+.
2. Clone this repository:

   git clone https://github.com/bernard-rr/interactive_column_mapping
   

3. Navigate to the project directory and set up a virtual environment:

   cd path-to-directory
   python -m venv venv
   source venv/bin/activate  # On Windows, use: .\venv\Scripts\activate
   

4. Install the required packages:

   pip install -r requirements.txt
   

5. Run the Streamlit app:

   streamlit run main.py
   

Usage

Uploading Your File:

1. Click on the "Browse files" button under "Choose an Excel or CSV file".
2. Navigate to the location of your Excel or CSV file and select it.
3. Once selected, the file will be uploaded automatically.

Specifying Desired Columns:

1. List your desired columns in the text area provided.
2. Use commas to separate column names.
3. Press CRTL + ENTER to apply.

Mapping Columns:

1. Use the drop-down selectors to map your desired columns to the columns from the uploaded Excel or CSV file.
2. If a desired column shouldn't map to any uploaded column, select "[Do not map]".

Processing & Downloading:

1. Click "Submit All Mappings".
2. After processing, a preview of your data will appear.
3. To download the processed data, click "Download zipped CSV file".

Troubleshooting

• File not uploading: Ensure the file is in .xlsx or .csv format. Other formats are not supported.
• Mappings not saving: Refresh the page and try again. Ensure all mappings are selected before submitting.

Contributing

Contributions are welcome! Please fork this repository and create a pull request with your changes.