3 ms·

I had Excel error out when I tried to open 10 million rows.

• sueders101 6y ago
  Excel tops out a little more over a million rows without specifically handling of larger files. I’m not sure excusing it, just a heads up to all the junior analysts out there who haven’t dealt with the problem(not implying you’re a junior analyst, just wanted to point something out to those who aren’t familiar with the issue).
  • logicOnly 6y ago
    No worries, Excel is nice for small/medium sized data and has the UI/Visualization which is nice. The story I mentioned was because I wanted to look at the data before I started parsing it. I had full expectations to use either sqlite or Pandas.