Skip to content
  • about

PyMarketer

>>> from pymarketer import blog, projects

Category: excel

Written by pymarketerJanuary 8, 2023January 10, 2023

pymarketer: an HTTP + Spreadsheet Wrangling Python package

Typically, this blog reviews the other Python libraries in its vast ecosystem. This time, it’s my own package I made for fun, pymarketer. This was created in a single day and can be installed from the Github repo. Have a go at my most read post if you need help with pip. Install with pip […]

Written by pymarketerDecember 21, 2019February 14, 2022

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 pymarketerNovember 30, 2019January 15, 2022

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 pymarketerMay 12, 2018October 29, 2021

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 pymarketerMarch 30, 2018October 29, 2021

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.
  • Follow Following
    • PyMarketer
    • Join 83 other followers
    • Already have a WordPress.com account? Log in now.
    • PyMarketer
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...