Change from real to generic names when importing from S3 to Data Wrangler (dataflow interface)
Hi
I've got a interface visualization trouble when I'm trying to import a csv file from a bucket. The data flow change automatically the names of the columns in a generic style as _c1, _c2, _c3...
Somebody knows who can I keep the name of the real columns in order to have a good appreciation of the names and analyze the data in this part of the Data Wrangler section.
Thanks a lot.
- Newest
- Most votes
- Most comments
Hello,
I understand that you tried to import a CSV file from an S3 bucket, but during visualization in Data Wrangler, the real names got changed to generic names, and would like to gather more information on the same.
Here, I would like to mention that in order to keep the original column names when importing a CSV file into Data Wrangler, you can follow below steps:
When importing the data, ensure that the "First row is header" option is checked under the Details section. This will preserve the column names from the first row of the CSV file. [1] [2]
Data Wrangler provides several sampling options, such as "None" to import the entire dataset, "First K" to sample the first K rows, "Randomized" to take a random sample, and "Stratified" to take a stratified random sample. You can choose the option that best suits your needs. [1]
Additionally, Data Wrangler supports importing data from various sources, including Amazon S3, using an S3 URI, S3 access point, or S3 bucket ARN. You can use these resource identifiers to import your CSV file. [1]
If you are still experiencing issues with the column names, you can try using the sampling transformer after importing the data to take additional samples from the dataset. [1]
I would request you to please try this at your end and let us know if you observe otherwise.
If you have any difficulty or if you still run into issues, please reach out to AWS Support [3] (Sagemaker ) along with your issue or use case in detail, and we would be happy to assist you further.
References:
[1] https://docs.aws.amazon.com/sagemaker/latest/dg/data-wrangler-import.html
[2] https://docs.aws.amazon.com/sagemaker/latest/dg/data-wrangler-getting-started.html
[3] Creating support cases and case management: https://docs.aws.amazon.com/awssupport/latest/user/case-management.html#creating-a-support-casehttps://docs.aws.amazon.com/awssupport/latest/user/case-management.html#creating-a-support-case
