Python: Beginner to Expert
John Lockwood 
Parquet and Arrow are two Apache projects available in Python via the PyArrow library. Parquet is an efficient, compressed, column-oriented storage format for arrays and tables of data. Arrow is an in-memory columnar format for data analysis that is designed to be used across different languages. It currently boasts supported libraries for several important languages, … Read more
Learning to write functions is an important step in learning to program. This set of practice Python functions and solutions is designed for beginners.
Happy Holidays from CodeSolid! I hope your holiday season is filled with all the good stuff – being with family and friends, and staying warm – and none of the bad stuff, like Seasonal Affective Disorder or being stuck in a snowbank. As usual, we’ll share a quick roundup of what’s new on CodeSolid and … Read more
Once you’ve learned the basics of writing functions, this list of Python function best practices will show you how to write functions that are easy to understand, use, and maintain.
As a beginner to Python programming, we learn how to call simple built-in functions. Indeed, the famous “Hello World” program in Python boils down to a single function call, so one could argue it’s the first thing we learn to do: As our skills improve, learning to not only call functions but how to write … Read more
Learn all about Python types, from how to explore information about them to how to ensure the correct types are passed to a function.
Hello, CodeSolid Subscriber, I hope you’re doing well. It’s time for another review of what’s new on CodeSolid and around selected parts of the rest of the Python Interwebs. New On CodeSolid On CodeSolid, our new author, Bashir Alam, has worked very hard on our Pandas Series, with two recent articles on Pandas: How to … Read more
Installing the Tools for the Pandas Series This article contains the instructions for installing the Python modules that you’ll need to run the code in our Pandas Series. If you need to do this, you can skip ahead to the section “Using the Project,” or feel free to read the next section for more background. … Read more
Dear CodeSolid Subscriber, Hello again. US readers, I hope you had an awesome Thanksgiving. Oh, let’s not be exclusive about this: I hope you had an awesome Thanksgiving no matter where you are. Thanksgiving was Thursday. As many of you know, I’ve been wrestling a bit with the frequency of this newsletter. Once per week … Read more
Use SQL as to query Python DataFrames using Pandasql and DuckDB. We share complete code examples for how to do this.
