Zoltan GubainPython in Plain EnglishFind External Links in Excel Using PythonChecking multiple Excel files for external links — in general or for a particular one — manually is not really effective. Can you find…Sep 18, 2023Sep 18, 2023
Zoltan GubainPython in Plain EnglishQuick Python Utility — How to Remove Sheet or Cell Protection from XLSX Files?In this article I would like to present a quick and dirty, however effective solution to remove passwords locking Excel worksheets and/or…Oct 9, 2022Oct 9, 2022
Zoltan GubainPython in Plain EnglishHow to Read DOCX Files With PythonProcessing large amounts of data is one of the use cases Python excels in. Sometimes however we don’t have the content we need in…Aug 21, 2022Aug 21, 2022
Zoltan GubainPython in Plain EnglishCombinations Vs. Permutations in PythonDid you know the Python methods for them?Mar 13, 2022Mar 13, 2022
Zoltan GubainPython in Plain EnglishHow to Analyse PowerBall Numbers with PythonPandas can’t Predict the Future. Can You?Mar 6, 20224Mar 6, 20224
Zoltan GubainPython in Plain EnglishHow to Automate Excel Formatting with PythonThe ultimate time-saver — script the styling with Openpyxl and Pandas.Feb 20, 2022Feb 20, 2022
Zoltan GubainPython in Plain EnglishHow to Join DataFrames in Python Using Pandas MergeTypes of Join and Their Implementation in PythonFeb 16, 20221Feb 16, 20221
Zoltan GubainPython in Plain EnglishAn Introduction to Python Exceptions and Exception Handling for BeginnersKnow, manage, and create your own Python exceptions.Feb 13, 2022Feb 13, 2022
Zoltan GubainPython in Plain EnglishHow to Self-Join Using PandasWrite your own utility function in Python.Feb 6, 2022Feb 6, 2022
Zoltan GubainPython in Plain EnglishInteractive Visualizations with Pandas, Seaborn and IpywidgetsCreate dynamic charts, save a ton of time.Jan 30, 20221Jan 30, 20221