Exemple #1
0
        static void CountryRegression()
        {
            List <string> countries = new List <string>();

            using (var connection = new SqlConnection(DataReader.ConnectionString))
            {
                connection.Open();
                string sql     = "SELECT DISTINCT Country FROM Users";
                var    command = new SqlCommand(sql, connection);
                using (var reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        countries.Add(reader.GetString(0));
                    }
                }
            }
            foreach (var country in countries)
            {
                var DAUTuple            = DataReader.DivideIntData(LinearRegression.GetIntPredictions(country, "DAU", "CountryClusterStatistics", "Country"));
                var NewUsersTuple       = DataReader.DivideIntData(LinearRegression.GetIntPredictions(country, "NewUsers", "CountryClusterStatistics", "Country"));
                var RevenueTuple        = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(country, "Revenue", "CountryClusterStatistics", "Country"));
                var ItemsTuple          = DataReader.DivideIntData(LinearRegression.GetIntPredictions(country, "Items", "CountryClusterStatistics", "Country"));
                var ItemsUSDIncomeTuple = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(country, "ItemsUSDIncome", "CountryClusterStatistics", "Country"));
                DataReader.UploadInfo(country, "CountryClusterPredictions", DAUTuple.Item1, DAUTuple.Item2, NewUsersTuple.Item2, RevenueTuple.Item2, ItemsTuple.Item2, ItemsUSDIncomeTuple.Item2);
            }
        }
Exemple #2
0
 static void ProfitRegression()
 {
     for (int i = 1; i < 5; i++)
     {
         var DAUTuple            = DataReader.DivideIntData(LinearRegression.GetIntPredictions(i, "DAU", "ProfitClusterStatistics", "ProfitClusterId"));
         var NewUsersTuple       = DataReader.DivideIntData(LinearRegression.GetIntPredictions(i, "NewUsers", "ProfitClusterStatistics", "ProfitClusterId"));
         var RevenueTuple        = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(i, "Revenue", "ProfitClusterStatistics", "ProfitClusterId"));
         var ItemsTuple          = DataReader.DivideIntData(LinearRegression.GetIntPredictions(i, "Items", "ProfitClusterStatistics", "ProfitClusterId"));
         var ItemsUSDIncomeTuple = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(i, "ItemsUSDIncome", "ProfitClusterStatistics", "ProfitClusterId"));
         DataReader.UploadInfo(i, "ProfitClusterPredictions", DAUTuple.Item1, DAUTuple.Item2, NewUsersTuple.Item2, RevenueTuple.Item2, ItemsTuple.Item2, ItemsUSDIncomeTuple.Item2);
     }
 }
Exemple #3
0
        static void CheatRegression()
        {
            List <bool> cheats = new List <bool>()
            {
                true, false
            };

            foreach (var cheat in cheats)
            {
                var DAUTuple            = DataReader.DivideIntData(LinearRegression.GetIntPredictions(cheat, "DAU", "CheatsClusterStatistics", "Cheat"));
                var NewUsersTuple       = DataReader.DivideIntData(LinearRegression.GetIntPredictions(cheat, "NewUsers", "CheatsClusterStatistics", "Cheat"));
                var RevenueTuple        = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(cheat, "Revenue", "CheatsClusterStatistics", "Cheat"));
                var ItemsTuple          = DataReader.DivideIntData(LinearRegression.GetIntPredictions(cheat, "Items", "CheatsClusterStatistics", "Cheat"));
                var ItemsUSDIncomeTuple = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(cheat, "ItemsUSDIncome", "CheatsClusterStatistics", "Cheat"));
                DataReader.UploadInfo(cheat, "CheatsClusterPredictions", DAUTuple.Item1, DAUTuple.Item2, NewUsersTuple.Item2, RevenueTuple.Item2, ItemsTuple.Item2, ItemsUSDIncomeTuple.Item2);
            }
        }
Exemple #4
0
        static void SexRegression()
        {
            List <string> genders = new List <string>()
            {
                "male", "female"
            };

            foreach (var gender in genders)
            {
                var DAUTuple            = DataReader.DivideIntData(LinearRegression.GetIntPredictions(gender, "DAU", "SexClusterStatistics", "Sex"));
                var NewUsersTuple       = DataReader.DivideIntData(LinearRegression.GetIntPredictions(gender, "NewUsers", "SexClusterStatistics", "Sex"));
                var RevenueTuple        = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(gender, "Revenue", "SexClusterStatistics", "Sex"));
                var ItemsTuple          = DataReader.DivideIntData(LinearRegression.GetIntPredictions(gender, "Items", "SexClusterStatistics", "Sex"));
                var ItemsUSDIncomeTuple = DataReader.DividedecimalData(LinearRegression.GetdecimalPredictions(gender, "ItemsUSDIncome", "SexClusterStatistics", "Sex"));
                DataReader.UploadInfo(gender, "SexClusterPredictions", DAUTuple.Item1, DAUTuple.Item2, NewUsersTuple.Item2, RevenueTuple.Item2, ItemsTuple.Item2, ItemsUSDIncomeTuple.Item2);
            }
        }