Python Forum
Opening CSV file from SFTP server not working - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Opening CSV file from SFTP server not working (/thread-25704.html)

Opening CSV file from SFTP server not working - cluelessintern - Apr-08-2020

Hello,

So after two days of scavenging the internet I have not found anything to help solve my issue. Any help or recommendations would be appreciated.


What I'm trying to do: There is an SFTP server that has a .csv file on it that I need to read. Downloading the csv and reading it is not an option as I'm developing a website.

I am currently using paramiko to access the server. It connects successfully. I use the following line of code to open the csv

 file = sftp.open('fixed.csv')
The problems:
1) when I try to use pandas read_csv, it only displays the first row of elements.

Please note this also happens if I open the csv file from my local computer and not the SFTP. So I am assuming I am just using this wrong.


 csv = pandas.read_csv(file)
    for line in csv:
        print(line)
2) I also tried using the built in csv library. The problem here is that it will not open the file, and I get an error: "TypeError: expected str, bytes or os.PathLike object, not SFTPFile"

Please note that if I open the csv locally using this method, it works perfectly fine. So I am assuming the problem has something to do with the filetype. 



with open(file) as csvfile:
        spamreader = csv.reader(csvfile)
        for line in spamreader:
            print(line)
I am at my wits end and have no idea how to proceed. Please let me know if I can provide additional information, thank you! Any help would be greatly appreciated.