Skip to content
  • About
  • Contact
    • Gracias un chingo

Python Marketer

Cross-Disciplinary Programming Explorations

Category: excel

Written by pythonmarketerDecember 21, 2019January 17, 2021

Copying a pandas Dataframe to Google Sheets with pygsheets

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 […]

Written by pythonmarketerNovember 30, 2019March 1, 2021

Inserting New Rows Into A Microsoft Access Database With Python and pyodbc

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 […]

Written by pythonmarketerMay 12, 2018November 6, 2020

A Stroll Through Pandas 1.0, Python’s Tabular Data Powerhouse

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 →

Written by pythonmarketerMarch 30, 2018January 26, 2020

Cleaning Data with Python and Excel: A Brief Example

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 […]

Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×