Today, I was granted access to Bing’s large language model, the next generation GPT-4. Bing’s chat is the “more powerful” successor to OpenAI‘s groundbreaking chat service that’s generating heaps of hype in addition to its AI text generation abilities. I gained the new chat functionality a few weeks after joining the Bing waitlist. A guilty […]
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 […]
Occasionally you will find a video or talk that connects or resonates with you in a great way. Rich Hickey’s “Hammock Driven Development”, a self-described “rant” is packed with wisdom. I keep coming back to re-watch and today, I have written down some key points from this amazing rant! Key Ideas Take more time to […]
If you write Python code, there’s probably been a time or two when you saw the dreaded “MemoryError”. This happens after one of your Python scripts stops because your computer has no spare RAM to execute it. I recently experienced this frustration whilst trying to write hundreds of thousands of csv files. However, this time […]
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 […]
Four years ago, I began studying Python as my first programming language. I have enjoyed it so much. I now enjoy going to work and writing Python scripts for up to 60% of a typical work day. I love the language. I’ve also dabbled in JavaScript, CSS and HTML, but have only applied those to […]
My research found that for creating a single-file Windows executable from a .py file, the front-running Python library is Pyinstaller. It worked on my Windows 7 PC. My program used a Gooey GUI, but many of the popular Python GUI libraries work as well. Installation: To install, enter this into command your command prompt or […]
Findstr is the Windows alternative to GREP, which runs on the Unix operating system. Findstr searches files with regular expressions and seems useful for string matching within files and directories. It is one of over 280 command prompt commands. Here’s the official Windows Documentation and some Linux vs. Windows Examples. Update: Windows announced that Grep and several other […]
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 […]
PyMarketer 