<commit_before>CREATE TABLE anonymous_session_gradient_boosting_bot_pred_table(
	revision_user                        VARCHAR(265),
	session_start                        BIGINT,
	session_end                          BIGINT,
	mean_in_seconds                      DECIMAL,
	std_in_seconds                       DECIMAL,
	namespace_0_edits                    INT,
	namespace_1_edits                    INT,
	namespace_2_edits                    INT,
	namespace_3_edits                    INT,
	namespace_4_edits                    INT,
	namespace_5_edits                    INT,
	namespace_120_edits                  INT,
	namespace_121_edits                  INT,
	edits                                INT,
	session_length_in_seconds            DECIMAL,
	inter_edits_less_than_5_seconds      INT,
	inter_edits_between_5_and_20_seconds INT,
	inter_edits_greater_than_20_seconds  INT,
	claims                               INT,
	distinct_claims                      INT,
	distinct_pages                       INT,
	distinct_edit_kinds                  INT,
	generic_bot_comment                  INT,
	bot_revision_comment                 INT,
	sitelink_changes                     INT,
	alias_changed                        INT,
	label_changed                        INT,
	description_changed                  INT,
	edit_war                             INT,
	inter_edits_less_than_2_seconds      INT,
	things_removed                       INT,
	things_modified                      INT,
	bot_prediction                       INT
);<commit_msg>Additional analysis for bot prediciton work<commit_after>CREATE TABLE anonymous_session_gradient_boosting_bot_pred_table(
	revision_user                        VARCHAR(265),
	session_start                        BIGINT,
	mean_in_seconds                      DECIMAL,
	std_in_seconds                       DECIMAL,
	namespace_0_edits                    INT,
	namespace_1_edits                    INT,
	namespace_2_edits                    INT,
	namespace_3_edits                    INT,
	namespace_4_edits                    INT,
	namespace_5_edits                    INT,
	namespace_120_edits                  INT,
	namespace_121_edits                  INT,
	edits                                INT,
	session_length_in_seconds            DECIMAL,
	inter_edits_less_than_5_seconds      INT,
	inter_edits_between_5_and_20_seconds INT,
	inter_edits_greater_than_20_seconds  INT,
	claims                               INT,
	distinct_claims                      INT,
	distinct_pages                       INT,
	distinct_edit_kinds                  INT,
	generic_bot_comment                  INT,
	bot_revision_comment                 INT,
	sitelink_changes                     INT,
	alias_changed                        INT,
	label_changed                        INT,
	description_changed                  INT,
	edit_war                             INT,
	inter_edits_less_than_2_seconds      INT,
	things_removed                       INT,
	things_modified                      INT,
	bot_prediction                       INT
);
{'fraction_non_alphanumeric': 0.025800130633572827, 'fraction_numerical': 0.014369693011103853, 'mean_word_length': 1.172340425531915, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1925759', 'n_tokens_mistral': 856, 'n_tokens_neox': 774, 'n_words': 141}