Python – What is a Dataframe?

A dataframe is a two-dimensional data structure, i.e., data is aligned in a tabular fashion in rows and columns, exactly as you would see in a classic Excel spreadsheet. In other terms, Pandas DataFrame is nothing but an in-memory representation of an Excel sheet via Python programming language.
Read More …

Python – Pandas – Using Dictionary to remap values in Dataframe

While working with data in Pandas, we perform a vast array of operations on the data to get the data in the desired form, before, for example, creating diagrams or passing to the visualization phase. One of these operations could be that we want to remap the values of a specific column in the Dataframe. This can be done in several ways. Read More …

Python – Pandas – Converting XLSX to Dictionary (key and values)

During data import process in a Jupyter Notebook, using Python and Pandas module for data science, we would need to manipulate or import directly an Excel file into a notebook and transfor all the data into a dictionary, so in this article we will focus on this particular need. Read More …