Reply to thread

Message

<blockquote data-quote="FrogReaver" data-source="post: 9072642" data-attributes="member: 6795602">I just went through reimporting my data.&nbsp; Had much fewer import errors after converting it to excel first.&nbsp; Only 8 vs 30,000 when doing so from csv.&nbsp; Either way, even if somehow that meant i don't have 8 characters in the data I'm not worried about that impacting the results.&nbsp; Chances are those rows weren't actually data rows in the import and thus the unimportable values.After reimporting my next step was to remove duplicates.&nbsp; After doing so I have 404,320 records, with 404,315 unique character ids.&nbsp; The 5 are duplicate character ids and either have different levels or different stats, different feats, etc.&nbsp; I plan to leave them in as the 5 entries shouldn't really change things and determining which to remove seems more problematic given the small number of entries.I guess the next step is to determine the logic for triming out invalid characters, like ones with 0 in a stat or don't have a subclass and should based on level.&nbsp; Etc.</blockquote>

[QUOTE="FrogReaver, post: 9072642, member: 6795602"] I just went through reimporting my data. Had much fewer import errors after converting it to excel first. Only 8 vs 30,000 when doing so from csv. Either way, even if somehow that meant i don't have 8 characters in the data I'm not worried about that impacting the results. Chances are those rows weren't actually data rows in the import and thus the unimportable values. After reimporting my next step was to remove duplicates. After doing so I have 404,320 records, with 404,315 unique character ids. The 5 are duplicate character ids and either have different levels or different stats, different feats, etc. I plan to leave them in as the 5 entries shouldn't really change things and determining which to remove seems more problematic given the small number of entries. I guess the next step is to determine the logic for triming out invalid characters, like ones with 0 in a stat or don't have a subclass and should based on level. Etc. [/QUOTE]

Verification