ELT Through Python

Language: Python

Libraries used:. Pandas , Requests

1. Pandas provides DataFrame which is a data structure that organizes data into a 2-dimensional table of rows and columns, much like Excel. DataFrames are one of the most common data structures used in modern data analytics because they are a flexible and intuitive way of storing and working with data.

2. Requests used for making HTTP requests to a specified URL. Whether it be REST APIs or Web Scrapping, requests are a must to be learned for proceeding further with these technologies. When one requests a URI, it returns a response.

The data extracted by hitting the target link is directly loaded into a dataframe,as the data which is being extracted is in the same structure of dataframe . So the data, in a simple iteration the data is appended into an excel file , depending on the approch choosed by the user.