d6tstack
d6tstack copied to clipboard
d6t
Quickly ingest messy CSV and XLS files. Export to clean pandas, SQL, parquet
example code `uri_mssql = f'mssql+pymssql://{u}:{p}@$server/$db' d6tstack.utils.pd_to_mssql(df = df, uri = uri_mssql, table_name = 'mytable', schema_name = 'myschema', if_exists='replace')` The error reads that I dont have access to the schema 'dbo'...
Hi, I'm trying to import a csv to a mssql server and I get the following error: ``` creating mysql.csv ok loading mysql.csv ok --------------------------------------------------------------------------- MSSQLDatabaseException Traceback (most recent call...
I've been using d6stack for months and have never had any problems, but recently this error message appeared below. How can I do to be able to solve this, without...
Proving an example to replicate this issue: Consider the following Pandas Dataframe called my_data: | id | coordinates | | 01| [50.1, 68.2] | |02| [52.2, 67.9] | and consider...
I have csv files and I'm trying to fix different columns between them. The function `d6tstack.combine_csv.CombinerCSV` works fine in other cases but now I have problems with the encoding. I...
use a database name with \ it ``` #server name is someserver123\data #database name = Comissions #no user name and password because Trusted_Connection = yes import pandas as pd import...
Allow to set the encoding when writing the dataframe to csv, before loading infile. It gets an error when the csv contains unicode characters.
The function pd_to_mssql uses BULK INSERT which requires the target file to exist on the same instance as the SQL Server. If you're running Python code on a remote machine,...
Hello everyone, I am having problems with the function d6tstack.utils.pd_to_mssql() when I want to import the Dataframe into Microsoft SQL Server database. The name of SQL Table is fxxProduktKatalogDE. I...
Hi, there is a spelling error. File "C:\Python37\lib\site-packages\d6tstack\utils.py", line 65, in **pd_readsql_table_from_sqlengine** return pd_readsql_query_from_sqlengine(uri, "SELECT * FROM {};".**fromat**(table_name), schema_name=schema_name, connect_args=connect_args) AttributeError: 'str' object has no attribute '**fromat**'
