Full data set not importing.

u1111082

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?

varunm1

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.

varunm1

Hello @u111082

Are you encountering any import error? or are you not able to see whole data? Which file format is this data in (Excel, CSV etc)?

u1111082

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.

varunm1

Hello @u1111082

That seems strange. Is it possible for you to share the data either here or through a private message available in community, so that I can check the issue?

u1111082

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

u1111082

Hi Varunm1, Brilliant! That worked. Thank you very much for your help.

asiddiq

Hi varunm1, Yes your solution is accepted but what could lead to such a problem. I did not get this error?
My data is fine but I want to know the causes!