Full data set not importing.

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)?

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.

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?

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

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.

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

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!