When working with data, you will often move between SQL databases and Pandas DataFrames. SQL is excellent for storing and retrieving data, while Pandas is ideal for analysis inside Python. In this article, we show how both can be used…
Tag: Pandas
Python – Data Wrangling with Excel and Pandas
Data wrangling with Excel and Pandas is actually quite useful tool in the belt of any Excel professional, financial professional, data analyst or a developer. Really, everyonecan benefit from the well defined libraries that ease people’s lifes. These are the…
Tagged with: combine reports, dataframes, Excel, export, filtering, fix, import, mergining, missing values, Pandas, Python
Simplifying Excel Tasks with Python: Data Handling and Testing Tutorial
Working with Python and Excel is actually quite handy, especially if you are into it. In this article, you can see how to create Excel files, write data and formulas into them and read these. Pretty much simple CRUD methods.…
Tagged with: Coding Tutorial, DataAnalysis, DataScience, ExcelAutomation, Openpyxl, Pandas, Python, UnitTesting
Python – Filtering values from a Pandas DataFrame
Some time ago, probably yesterday or the day before, I had to filter a pandas dataframe and somehow it did not come intuitively into my mind how to do it. As I did not have an article about it, I…
Python – Plotting DataFrame and Working with Pandas – Video
Working with Pandas is like working with Excel on steroids – it can really do a lot of things fast, but somehow doing the easy things get complicated. In this video and article tutorial I am presenting loading data to…
Numpy and Pandas – Small introduction with Jupyter Notebook
Last week I was participating at the Python and ML Summit in Berlin. One of the most interesting lectures, on which I participated, was a workshop by, named “Reading all yourself was yesterday – How to turn large amounts of…
Top