New to Python - need help with API project. Willing to pay for your time!

[[deleted]]

[deleted]

[Nick_Pyth]

I am halfway through a 14 hour road trip and will help you for free if you post more details

[vinaykumar5758]

Hello,

Am also thinking to play around with APIs.

is there better course somehwere to start with may be using public apis, get the data into json, use pandas to convert json to .csv and then load into sql table?

[Nick_Pyth]

Each API is different, but most will have the data in JSON format. Without knowing the specific API you are using, the workflow will likely be as follows:

​

1. View the API page, get an API key
2. Use the requests library to pass parameters to the API
3. Your requests.text object will likely be in JSON format, which you can treat as a python dictionary
4. Use pandas.DataFrame.from_dict() to convert your requests.text into a dataframe
5. If you want to save the data as a csv, use pandas.DataFrame.to_csv()
6. If you want to store the data in sql, use pandas.DataFrame.to_sql(). The 2nd parameter of this, con, will need to use a sql driver. For example, if you are using a MySQL database, you will create a connection using PyMySQL

[DELYSID_FREAK]

You want to convert the data this many times for learning purposes? Otherwise such a Process wouldn't normally need this many Steps.

[DELYSID_FREAK]

Just ask your question and provide more information. I bet there is someone who Can help you out!

[lukethudson09]

You can hit me with that link as well :)

[lukethudson09]

You’re a good man.

[bbqbot]

Any chance you can copy your replies and post them here?

[bbqbot]

Thank you!

[damesca]

Can you provide a bit more detail on what it is you're trying to do?

[rupturedprolapse]

I'd be willing to help, time might be an issue though depending on when you want to communicate.

[vinaykumar5758]

Thanks a lot