I would like to create a flat file and drop it to a SFTP server. I did set up the connection.
First I created a managed folder and used the recipe 'Export to folder'. It worked , but I have a limited choice of format. And obviously ".txt" is not on the list.
Then I used a python recipe to export the file in the managed folder :
# -*- coding: utf-8 -*- import dataiku import pandas as pd, numpy as np from dataiku import pandasutils as pdu # Read recipe inputs test = dataiku.Dataset("TEST") test_df = test.get_dataframe() folder_name=dataiku.Folder("v2") folder_name_path=folder_name.get_path() test_df.to_csv(path_or_buf=folder_name_path+"/project.txt",index=False,sep=";")
But I have the following Error:
This code work for a managed folder on my local server.
So I'm wondering how I can create a txt files on a ftp folder.
Thanks in vance
You need to declare your output folder as well like this
out_folder = dataiku.Folder("some_sftp_folder")
Then you can generate the csv of your dataframe and upload it to the folder
filename = "some_file_name.csv" data = test_df.to_csv(index=False) out_folder.upload_data(filename, data)
Hope this helps!