Convert an API csv like data into Python dataframe.

There is API data from Replicon.com that is in a CSV-like format but not precisely.
I need to convert or clean this into a data frame so that I can save it to the database.
Hence, I might need a Python function that gets this big string format text, removes the header, separates fields data, and converts it into a data frame so that it can be saved to an SQL database.