1

These are the three main resources I've been mainly using to try to either use the Google Sheets API or manipulate an excel spreadsheet on Pycharm:

For this link this is the error I get: Not installing gspread Screenshot

When I try to install pandas I get this: Not installing pandas Screenshot

On this link, once you get to time 2:13 (it shows the available packages to download from the settings), nothing seems to come up on my screen.Yes I have googled these, but I'm pretty new to this so I don't know exactly where to go from here. Doing this project with Excel was my work around to not being able to work with google sheets, but I'm kind of stuck now.

*Assume I've followed the steps mentioned here, which I have. If you don't want to watch the first youtube video since it's pretty long, here's a tutorial he wrote on his website exactly the way he did it on the video:

Improve this question
1
  • Note that you can always manually install packages from PyPI -- oauth2client - gspread - pandas. Note, however, that those modules likely have dependencies (such as numpy for pandas) that may also need to be manually downloaded as well (tedious but doable).
    – Anaksunaman
    Commented Aug 25, 2019 at 4:38

1 Answer 1

Reset to default
0

I finally solved the solution. To be honest a guy at work solved it. It was something I probably wasn't gonna figure out unless someone from work new what they were doing due to our proxy servers. But basically there's a very specific way I had to set up my proxy. But now all I have to is is go into the terminal and type

SET http_proxy=http://(PROXY ADDRESS):PORT

SET https_proxy=https://(PROXY ADDRESS):PORT

I tried doing all this on my personal computer and I did not have any issues installing anything. That's what got me going around asking for help at work

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .