Full data set not importing.
u1111082
New Altair Community Member
I have a data set of about 300,000 examples but when I import the data set I only get 93,925 rows. Is there a way around this?
Tagged:
0
Best Answer
-
Hello @u1111082
There are some value positioning errors while loading this CSV file. The quotes in your data file are causing these issues. So, you need to uncheck the option present in "Specify your data format" window. See image below.
5
Answers
-
Hi Varunm1, thanks very much for your reply. I have no import error. I am just unable to see the whole data. When I look at the results/data tab it tells me 93000 examples at the bottom of the screen, yet when looking in Excel it has over 300,000 rows. I am using a CSV file.0
-
Hi Varunm1, thanks again for following this up. Yes its just a publicly available data set (road crash data, approx 165MB). You will find the link to the data set at the top of the web page below (re road crash locations). Much appreciated.
https://www.data.qld.gov.au/dataset/crash-data-from-queensland-roads/resource/e88943c0-5968-4972-a15f-38e120d72ec0
0 -
Hello @u1111082
There are some value positioning errors while loading this CSV file. The quotes in your data file are causing these issues. So, you need to uncheck the option present in "Specify your data format" window. See image below.
5 -
Hi Varunm1, Brilliant! That worked. Thank you very much for your help.
0