Disclaimer: This endeavor was before I discovered AppScript, which may be an alternative solution to using pygsheets or other python libraries. pygsheets is interesting, but it could be a stretch to justify using it for something that could be done with AppScript. Both are ways to solve a problem by automating Google Sheet operations. This […]
I recently automated the loading of data into a Microsoft Access database with pyodbc, a Python library for connecting to databases. ODBC stands for Open Database Connectivity. It can be used for a variety of Database Management Systems outside of Access also. First, install libraries with pip. Enter in terminal or command prompt: python -m […]
Thanks to Pandas, I have automated some data cleaning and file reading processes at my job. Here are some terms and code that have been useful or interesting to me after 14 months of exploration. I’ve also checked out “Python for Data Analysis” from the epic Chicago Public Library system, so bits of this has … Continue reading Pandas, Python’s Excel Powerhouse
I want to show a simple, real world problem and solution I made today with Python. Problem: My data has been corrupted (over 8,000 rows in Excel). Somewhere in my haste, I have scrambled first names and last names in the ‘first name’ and ‘last name’ field. Solution: Find unique words from both fields, which leads […]