Full data set not importing.

u1111082
u1111082 New Altair Community Member
edited November 5 in Community Q&A
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:

Best Answer

Answers

  • varunm1
    varunm1 New Altair Community Member
    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
    u1111082 New Altair Community Member
    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
    varunm1 New Altair Community Member
    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
    u1111082 New Altair Community Member
    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
    u1111082 New Altair Community Member
    Hi Varunm1, Brilliant! That worked. Thank you very much for your help.
  • asiddiq
    asiddiq New Altair Community Member
    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!

Categories