help on sentiment analysis: limiting rows by sentiment value

[jshinnn]

Hi, i'm developing a data visualization and want to do something similar to this. However, my text is too large so there are a lot of rows in the table. is there a way to limit the number of rows in a table, or sort the rows by ascending / descending sentiment value, or filter out what shows up in the rows based on if it's above a certain sentiment value? Thanks!

[sanjayaksaxena]

Hello @jshinnn

There could be several ways this can be achieved depending on the context and volume of the data. Here is a simple way to only show rows with sentiment > threshold value (0.2 in the example):

Best,
Sanjaya

[jshinnn]

hey Sanjaya, thanks for your thoughtful reply! this worked table-wise but unfortunately i see the text that is used to build the rows of the table presented right before the row. see below: any tips?

[sanjayaksaxena]

Hi @jshinnn

Seems strange! The code contained in the Observable notebook and also the code suggested above should not exhibit this behaviour.

Can you share the code that is being used in your notebook?

Best,
Sanjaya

[jshinnn]

hi @sanjayaksaxena , i tried it on some smaller text with the code you suggested and am having the same problem. the link to the observable notebook is here. thank you!

[sanjayaksaxena]

My bad @jshinnn! Here is the working code with a threshold 0.45:

[jshinnn]

@sanjayaksaxena thank you so much! i appreciate it. as i am analyzing a large dataset, being able to filter helps a lot but i was wondering if there's a way to make the table scrollable in a fixed frame? otherwise, the table is very large as there are many sentences in my dataset. please let me know if this doesnt make sense.

[sanjayaksaxena]

Consider using Observable Table... It will require you to make some changes in the code:

[jshinnn]

@sanjayaksaxena this is great, thanks so much! one last question, do you know how to make it so that the text in the "sentence" column shows all the words? for example, some sentences are too long so they end in ellipses. i tried looking on the observable table input page directly but can't seem to find a solution.

[rachnachakraborty]

Hey @jshinnn

Setting the layout to auto should display the entire content of a cell.

Citing from observable table input page

There’s a similar _width_ option if you want to give certain columns specific
widths. The table component defaults to a fixed _layout_ if there are twelve or
fewer columns; this improves performance and avoids reflow when scrolling.

You can switch _layout_ to auto if you prefer sizing columns based on content.
This makes the columns widths resize with the data, which can cause the columns
to jump around as the user scrolls. A horizontal scroll bar is added if the
total width exceeds the table’s width.

Hope this helps.

Best,
Rachna

[jshinnn]

hello @rachnachakraborty thank you so much! i was wondering if it's possible to display the full text but in rows, instead of horizontal scrollbar as the auto layout produces.