开发者

Suggestions on Data Exploration/Visualization from the Browser of a table of 10,000 rows and 5 columns?

开发者 https://www.devze.com 2023-01-24 19:00 出处:网络
Is my dataset too large for people to explore from the browser? The size of the json_data.js is 550KB.

Is my dataset too large for people to explore from the browser?

The size of the json_data.js is 550KB.

Dimension are 5 columns and 10,000 lines. (3 columns of words, 1 of dates, and 1 of integers)

Basically I have 10,000 of these lines "Id|Activity_Title|Location|Start|Du开发者_StackOverflow中文版ration"

I had initially hoped to use 2 jquery plugins, tablefilter and tablesorter, but they make my browser freeze with this large dataset (though they have worked great with smaller datasets).

Can anyone suggest alternative ways or approaches (or plugins) to summarize and visualize datasets of 10,000 rows and 5 columns using just javascript and the browser.


The traditional way to handle this is through pagination, but that's not the best approach.

The best thing to do is to provide a smart initial filter for the data plus tools for the user to easily expand or narrow the filter. It's pointless to show the user 10,000 rows. But generally you can project based on your application's business rules what rows the user really wants to see. Are they most likely to want the most recent records? Or maybe most recent in a particular location? Or some other common criteria? The better you can provide them with a smart initial list, the better user experience they'll have.

After that initial list is available, give them tools to expand or narrow the list further. When they do eventually get a list that is too big to show (usually no more than 50 rows per page, often 20) then use paged data to only show a small subset of rows at a time.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号