Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DataFrame Handling for Dict Bulk2.0 #702

Open
a844713 opened this issue Dec 15, 2023 · 0 comments
Open

DataFrame Handling for Dict Bulk2.0 #702

a844713 opened this issue Dec 15, 2023 · 0 comments

Comments

@a844713
Copy link

a844713 commented Dec 15, 2023

Hi.

To use the bulk2 method, is any prior data processing necessary?

I obtain my data from a DataFrame and convert it into a list of dictionaries using the pandas to_dict(orient='records') method. However, when executing the action, my data is inserted successfully, but a small portion of it fails in each batch.

Upon evaluating the functions, I came across the _convert_dict_to_csv function and noticed that it uses a comma as the default separator.

My concern is that my data contains both periods (".") and commas (",") in its content. For example: "Text 08 20 15,05B,05Cu,1Mn,1Zn"

Do I need to apply any specific treatment to handle these punctuation marks in my fields?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant