In this tutorial, I will show you an overview of using OpenPyXL and Python to read and write Excel documents. You will also learn how to: Style cells Change fonts Create named styles Use pandas with Excel Combine pandas and OpenPyXL Basics of using XslxWriter The code in this tutorial is based on code from […]
Automating Excel with Python Video Overview Read More »
This week we welcome Daniel Gaspar as our PyDev of the Week! Daniel is the co-author of Mastering Flask Web Development. If you would like to see what else Daniel has been up to, you should check out his GitHub profile. Let’s spend some time getting to know Daniel better! Can you tell us a
PyDev of the Week: Daniel Gaspar Read More »
This week we welcome Kalob Taulien (@KalobTaulien) as our PyDev of the Week! Kalob is a WagtailCMS core dev, which is a CMS on top of the Django web framework. You can catch up with Kalob by going to his website where you can check out some of Kalob’s bootcamp courses. Let’s spend a few
PyDev of the Week: Kalob Taulien Read More »
This week we welcome Jessica Greene (@sleepypioneer) as our PyDev of the Week! Jessica is a backend engineer at Ecosia and is an active member of PyLadies. She also gives talks at multiple tech conferences. You can see some of what Jessica is up to over on GitHub. Let’s spend some time getting to know
PyDev of the Week: Jessica Greene Read More »
This week we welcome Anna Makarudze (@amakarudze) as our PyDev of the Week! Anna is a Django Girls Foundation Trustee & Fundraising Coordinator and DSF President. You can learn more about Anna by checking out her website. Let’s spend some time getting to know Anna better! Can you tell us a little about yourself (hobbies,
PyDev of the Week: Anna Makarudze Read More »
I was recently contacted by https://www.developrec.net/ to create a video about Python. Here is the result:
5 Tips on Learning Python From Zero Read More »
This week we welcome Henry Schreiner (@HenrySchreiner3) as our PyDev of the Week! Henry is an open-source maintainer/core contributor to multiple projects related to scikit, PyPA, and more. You can get a feel for what Henry is up to by checking out his GitHub profile. Henry also created a “Level Up Your Python” course that
PyDev of the Week: Henry Schreiner III Read More »
This week we welcome Leonardo Giordani (@tw_lgiordani) as our PyDev of the Week! Leonardo is the author of Clean Architectures in Python. Leonardo also writes lots of articles on his website. Let’s take a few moments to get to know Leonardo better! Can you tell us a little about yourself (hobbies, education, etc): I’m Italian,
PyDev of the Week: Leonardo Giordani Read More »
My talk, Creating GUIs with PySimpleGUI, is up on YouTube. I gave this talk to the SFPython / PyBay groups in January 2022. I used Jupyter Notebook for the slides of this talk. All the slides and example code are available in my GitHub Talks repo. You can learn more about PySimpleGUI in the
Creating GUIs with PySimpleGUI (Video) Read More »
This week we welcome Roman Right (@roman_the_right) as our PyDev of the Week! Roman is the creator of Beanie, an Asynchronous Python object-document mapper (ODM) for MongoDB. You can see what else Roman contributes to over on GitHub. Let’s take some time to get to know Roman better! Can you tell us a little about
PyDev of the Week: Roman Right Read More »
My latest Python book, Automating Excel with Python is now on ProductHunt If you have a ProductHunt account, I would appreciate it if you voted the book up. The book is currently available for purchase on Leanpub or Gumroad or Amazon
Automating Excel with Python Now on ProductHunt Read More »
This week we welcome Batuhan Taskaya (@isidentical) as our PyDev of the Week! Batuhan is a core developer of the Python language. Batuhan is also a maintainer of multiple Python packages including parso and Black. You can see what else Batuhan is up to by checking out his website or GitHub profile. Let’s take a
PyDev of the Week: Batuhan Taskaya Read More »
This week we welcome Sundeep Agarwal (@learn_byexample) as our PyDev of the Week! Sundeep has authored more than 10 books about RegEx, Awk, Python and more! You can see what else Sundeep has been up to by checking out his blog or his GitHub profile. Let’s spend some time getting to know Sundeep better! Can
PyDev of the Week: Sundeep Agarwal Read More »
PySimpleGUI is a Python GUI that wraps other Python GUI toolkits (Tkinter, PySide, wxPython). By abstracting away the complexities of the other GUIs into a common API, you can quickly write code that can be rendered using any of those other toolkits just by changing the import at the top of your program. If you
PySimpleGUI – An Intro to Laying Out Elements Read More »
This week we welcome Julian Sequeira (@juliansequeira) as our PyDev of the Week! Julian is one of the co-founders of PyBites. They post articles, courses, run a podcast and have a fun Code Challenge site too. You can connect with Julian on LinkedIn if you’d like to. Now let’s spend some time getting to know
PyDev of the Week: Julian Sequeira Read More »