This is my first blog on C# Corner on Python technology. Nowadays, Python is a very popular data science language that is easy to use, OOPs-based, and needs much less coding.
First, install Python, which is open source and available for all platforms, and you can download it from the link - https://www.python.org/downloads/.
Steps for Windows installation are easy.
Second, install Anaconda Manager from the link - https://docs.anaconda.com/anaconda/install/windows and follow the installation steps.
Third, search and open Anaconda Prompt. Now, install pandas by typing 'pip install pandas'.
Forth, find and open jupyter notebook. Copy and paste the below code to convert unstructured data into structured format.
I have attached the zip file of the code that contains the files jupyterSample.ipynb and sample.xlsx.
Try it and give your suggestions to make it better.
Best of luck.