powcyan

<p>Plugin that selects columns from all wordpress.<br />
* Databases, displays their contents, and outputs them in CSV format.</p>
<h4>Main function</h4>
<ul>
<li>Read and display all WordPress databases and their columns, and output them as CSV</li>
</ul>
<h4>Premium Add-ons</h4>
<p>For a list of available extensions, see [Web site] (https://wspri.dip.jp).</p>
<h4>Translation</h4>
<p>This plug-in will display Japanese if the browser is set to Japanese, and will display English if it is any other language.</p>


Select table and column and output in CSV

Plugin that selects columns from all wordpress.

James Luberda

<p>(if you are not familiar with Zipf’s law, you may wish to look at the screenshots first, as they provide a visual context for the following)</p>
<p>Zipfstats is built around Zipf’s law, which states that given some corpus (in this case, a post/page) of natural language, the frequency of any word is inversely proportional to its rank in the frequency table. In a perfect Zipfian distribution, this would mean that the most frequent word in the corpus will occur twice as often as the second most frequent word, three times as often as the third most frequent word and so on. Any given real world corpus, if large enough, will tend to approximate a Zipfian distribution (this also works for cities as ranked by population, though that observation is less useful in this context).</p>
<p>The Zipfstats widget analyzes and reports word frequency by rank of a given single post or page (aka the corpus). The widget shows a small graph that plots the actual frequency-rank distribution of the content against a perfect Zipfian distribution, thus illustrating the degree to which the content follows Zipf’s law. It also provides for a table of the top-ranked words.</p>
<p>Zipfstats only analyzes the core content of a given post/page. It does not incorporate comments into its calculations. By default, it removes shortcode-generated content from its analysis, though you may optionally enable it. Filters, other than do_shortcode() (in the aforementioned case), are not affected in terms of the analysis. Actual output of the original content is unchanged, regardless of the options selected.</p>
<p>Options</p>
<ul>
<li>Show Only to Admin Users (default = on): only admin-level users see Zipfstats output. If unchecked, all users, logged or non-logged, will see it.</li>
<li>Strip Shortcode Content from Analysis (default = on): skips processing of and removes all shortcodes from the content of the post or page prior to analysis. Actual content remains unaffected.</li>
<li>Include Graph (default = on): Display a log-log plot of word frequency data against a perfect Zipf distribution</li>
<li>Include Word Frequencies (default = on): in addition to the Zipf plot, this option includes a table of the top n words in rank order as well as the frequency of their occurrences in raw terms. A clickable header allows the user to toggle between showing/hiding the wordlist.</li>
<li>Expand Word Frequency Table by Default (default = on): if expand is selected, the wordlist (if also selected) will be displayed on initial page load. Unchecked, the user will have to toggle its display manually via a clickable header.  </li>
<li>Number of Words to Show (default = 10, max 25): this determines the number of words to appear in the “top n” wordlist table, if the latter is enabled. This option does not affect any calculations.</li>
</ul>
<p>Some things to note:</p>
<ul>
<li>No site data is modified or stored. Widget results are generated on the fly. Zipfstats does not directly initiate any database activity, but merely uses the the $post object to analyze content, and the WordPress widgets API to store a handful of options.</li>
<li>Post/page content will be displayed as normal. If the widget is added to a sidebar, it will appear where placed, again, without any change to existing post/page content.</li>
</ul>
<h4>Future Enhancements</h4>
<ul>
<li>Add site-wide/category-wide/author-wide analyses</li>
<li>Add to admin post/page edit</li>
<li>Add recommendations to better approximate a Zipfian distribution</li>
</ul>


Zipfstats

Zipfstats provides a widget plotting the frequency each word appears in a post/page and its rank (most frequent->least) against a Zipf distribution …

Select table and column and output in CSV vs Zipfstats