CSV Programs

Concept

In my position as a Juinor Software Developer, I created various Python programs that worked with CSV files. The CSV files were used to update/insert/delete data from the relational database in Salesforce that contained data on the clients of my company. A GUI was implemented to allow employees from the marketing team to use the program.

Project Description

In this program, a tkinter GUI prompts a user to choose a csv file that contains phone numbers. The script then runs a loop that sends API requests to Telnyx to gather information in a JSON format regarding the phone numbers. The JSON is then parsed and written to an output CSV file. The program runs in loops with a time delay to stay within the free API limit.

Project Description

This program mimics the function of the compare tables function in Ablebits from Microsoft Excel. Once the program is run, a tkinter GUI prompts a user to choose two CSV files. One file contains on column for the primary keys and another column with values for commparison. The second CSV file contains a column with values to be compared with the first CSV file. The resulting output file will contain only the rows that had a matching value and save to a folder with a timestamp. In order to reduce the time complexity, an array is used to hold the values of the bounced emails. *Note: The bounced_emails.py file in the repository is a varaition of the compare_two_tables program with the purpose of finding household ID's with emails that need to be deleted from a database.

Project Description

In this program, all the csv files in a directory is merged into one csv file. The columns in the csv files can be renamed and selected before a final output csv file is created with the combined data of the csv files from the chosen directory. A Tkinter GUI is used to allow useres to select the input folder. The name of the output csv file is set to the name of the input folder with a datetime stamp.