Can someone explain me what is this problem? I downloaded wget on windows and I tried to show a table in jupyter notebook but I have this error, although when I go on this page, this file downloads. What is the problem? Thank you in advance! 
Asked
Active
Viewed 2,434 times
0
desertnaut
- 57,590
- 26
- 140
- 166
prostak
- 139
- 6
-
1Did you check if the file is actually downloaded? `No such file or directory` error tells that the file you are trying to read is not found. – Kabilan Mohanraj Dec 23 '21 at 21:36
-
@KabilanMohanraj I thought !wget command shouldn't download this file on my computer. I thought it just should copy this table from site to notebook. But what I should to do to solve it, because this file hadn't download. – prostak Dec 23 '21 at 21:44
-
Try to read the file in as csv? https://stackoverflow.com/questions/37243121/using-pandas-to-read-in-excel-file-from-url-xlrderror – jtessier72 Dec 23 '21 at 21:45
-
1@prostak The answer in this superuser post should be useful. https://superuser.com/a/470706/1189221 – Kabilan Mohanraj Dec 23 '21 at 21:49
-
@KabilanMohanraj But that is about linux. – prostak Dec 23 '21 at 21:57
-
@KabilanMohanraj Ou, I have this files on the homepage of jupyter notebook, but anyway I can't read it – prostak Dec 23 '21 at 22:01
-
1Try specifying the complete path of the file in the `read_excel` function. – Kabilan Mohanraj Dec 23 '21 at 22:04
-
It doesn't work. – prostak Dec 23 '21 at 22:19
-
1Are you still getting the same error? – Kabilan Mohanraj Dec 23 '21 at 22:36
-
1If you want to read the table without downloading the file. `pandas.read_excel` can take as its first argument accept a valid `http`, `https` or `s3` URL as well – ashutosh singh Dec 23 '21 at 22:40
-
1Can you run the `wget` command without the `-q` flag? This way, we can see what the `wget` command's output is. – Kabilan Mohanraj Dec 23 '21 at 23:18
-
Then I get the error "'https://www.dropbox.com/s/ysxs5srafoyxknb/_data_3_course.xlsx?dl=1': Scheme missing." – prostak Dec 23 '21 at 23:22
-
These files are in my computer's directory, but they have weight 0 bytes and I don't know why. – prostak Dec 23 '21 at 23:27
-
Thank you. Problem is solved) – prostak Dec 23 '21 at 23:46
-
Can you post the resolution as an answer? Was it the apostrophe? – Kabilan Mohanraj Dec 23 '21 at 23:52
1 Answers
0
In the first order you need to write -q + "url", and then you need to write -O + "name. I mean just swap them like: !wget -q "url" -O "name"
prostak
- 139
- 6