Reply to thread

Message

<blockquote data-quote="ichabod" data-source="post: 9072107" data-attributes="member: 1257">How are you removing duplicates? What about other data trimming, like the characters with all 0's for stats? I've come up with a subset of the data base with about 400,000 rows. The criteria I am currently using for subsetting is that a retained character must:<ul>
<li data-xf-list-type="ul">Not have 'test', 'character', or 'npc' in it's name.</li>
<li data-xf-list-type="ul">Not have a blank name.</li>
<li data-xf-list-type="ul">Have a(n extended) point buy cost of greater than zero and no more than 55.</li>
<li data-xf-list-type="ul">Have a background</li>
<li data-xf-list-type="ul">Have a standard class (PHB + Artificer)</li>
<li data-xf-list-type="ul">Have an official sub-class</li>
<li data-xf-list-type="ul">Be at least level 2.</li>
</ul>I put in the max on point buy cost because I found a bunch of characters with all 18s (and realize that the stats given are the starting stats without racial modifiers or ASI's). And I took out the first level characters because there's way too many of them. Over half the data is first level characters, and I don't think they were every played.</blockquote>

[QUOTE="ichabod, post: 9072107, member: 1257"] How are you removing duplicates? What about other data trimming, like the characters with all 0's for stats? I've come up with a subset of the data base with about 400,000 rows. The criteria I am currently using for subsetting is that a retained character must: [LIST] [*]Not have 'test', 'character', or 'npc' in it's name. [*]Not have a blank name. [*]Have a(n extended) point buy cost of greater than zero and no more than 55. [*]Have a background [*]Have a standard class (PHB + Artificer) [*]Have an official sub-class [*]Be at least level 2. [/LIST] I put in the max on point buy cost because I found a bunch of characters with all 18s (and realize that the stats given are the starting stats without racial modifiers or ASI's). And I took out the first level characters because there's way too many of them. Over half the data is first level characters, and I don't think they were every played. [/QUOTE]

Verification