Best Of

Data format from Jupyter to Dataset

I'm facing the issue of transforming the dataframe to domo dataset.

I have cleaned dataset, merge, join etc and make my dataframe beatifull, then the issue happen when I export by the domo.write_dataframe, the domo dataset change the the format of dataframe and it definitely not what I want.

What a waste if we have to transform data again, right?

Anyone facing or have solution for this will be appreciated.

Here is the screen shot for some fields.

thinh_dao

1

Re: Data format from Jupyter to Dataset

I was having a similar issue with a date column that changed to text when I wrote the data frame to a dataset in Domo. I played with the different dtypes, and found one that did stay as a date after moving to Domo (though the timezone changed, so it ended up being a few hours different than what I had in Pandas). Domo doesn't have an int data type, so maybe try changing it to a float to see if gives you something numeric once it's in Domo?

DavidChurchman

1

Re: SFTP Pull Connector

I do this with code outside of Domo. I created a small visual basic executable that downloads from an sftp site, to a local file. It then copies and renames the file to something easy for me to upload into Domo using Domo Workbench. I also copy a dated version to a folder so I can keep a history.

You can also script with WinSCP. But that's probably similar to what you are doing with FileZilla.

The following is a generic version of code in case its helpful to someone -

To download an Excel file from an SFTP server using VB.NET, you can use the SSH.NET library, which provides SSH and SFTP functionality. You'll need to install the SSH.NET NuGet package to your project.