Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
hello community,
can anyone tell me is there any way to upload .csv files to CDF using Python SDK.
Solved
.csv file Ingestion into CDF using Python SDK [Community Contributed]
Best answer by roman.chesnokov
import numpy as np
import pandas as pd
from cognite.client import CogniteClient
DATABASE_NAME = "db"
TABLE_NAME = "table"
CSV_FILENAME = "source.csv"
client = CogniteClient()
client.raw.databases.create(DATABASE_NAME)
client.raw.tables.create(DATABASE_NAME, TABLE_NAME)
df = pd.read_csv(CSV_FILENAME, index_col=0).fillna('')
client.raw.rows.insert_dataframe(DATABASE_NAME, TABLE_NAME, df)
To upload an actual file, check out:
https://cognite-sdk-python.readthedocs-hosted.com/en/latest/cognite.html#upload-a-file-or-directory
Or do you want to read the data and upload for example the rows as assets?
import numpy as np
import pandas as pd
from cognite.client import CogniteClient
DATABASE_NAME = "db"
TABLE_NAME = "table"
CSV_FILENAME = "source.csv"
client = CogniteClient()
client.raw.databases.create(DATABASE_NAME)
client.raw.tables.create(DATABASE_NAME, TABLE_NAME)
df = pd.read_csv(CSV_FILENAME, index_col=0).fillna('')
client.raw.rows.insert_dataframe(DATABASE_NAME, TABLE_NAME, df)
+2Hi
We appreciate your contribution to our community hub! We have chosen to move your article to our hub's How-To section as it will greatly benefit other members of our community. Thank you for your understanding, and we look forward to seeing more great contributions from you in the future!
Best regards,
Dilini
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.