示例#1
0
        public void Read(string file)
        {
            Console.WriteLine("Reading data from file : {file}");
            try
            {
                string[] lines = File.ReadAllLines(file);
                for (int index = 0; index < lines.Length; index++)
                {
                    string   line   = lines[index];
                    string[] values = line.Split(',');

                    CrimeStats crimeStat = new CrimeStats();
                    crimeStat.Year               = Int32.Parse(values[0]);
                    crimeStat.Population         = Int32.Parse(values[1]);
                    crimeStat.Murders            = Int32.Parse(values[2]);
                    crimeStat.Rapes              = Int32.Parse(values[3]);
                    crimeStat.Robberies          = Int32.Parse(values[4]);
                    crimeStat.ViolentCrimes      = Int32.Parse(values[5]);
                    crimeStat.Thefts             = Int32.Parse(values[6]);
                    crimeStat.MotorVehicleThefts = Int32.Parse(values[7]);

                    crimeStatsList.Add(crimeStat);
                }
                Console.WriteLine("Reading completed.");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Unable to read CSV file. Please try again.");
                throw ex;
            }
        }
示例#2
0
        static void Main(string[] args)
        {
            string file;
            string report;

            Console.WriteLine("Please enter in a file path for your csv file");

            file = GetValidDocument();

            Console.WriteLine("Now enter in a file path for the report file");

            report = Console.ReadLine();

            if (report == null)
            {
                Console.WriteLine("Enter in a report filename");
            }

            CrimeStats crimeStats = new CrimeStats();

            if (File.Exists(file))
            {
                crimeStats.Read(file);
                var fileReader = File.Create(report);
                fileReader.Close();
                crimeStats.linqWriting(report);
            }
            else
            {
                Console.WriteLine("Please enter in a CSV file that can be used with data that's not: {file}");
            }
        }
示例#3
0
        public static List <CrimeStats> Load(string csvDataFilePath)
        {
            List <CrimeStats> crimeStatsList = new List <CrimeStats>();

            try
            {
                using (var reader = new StreamReader(csvDataFilePath))
                {
                    int lineNum = 0;
                    while (!reader.EndOfStream)
                    {
                        var info = reader.ReadLine();
                        lineNum++;
                        if (lineNum == 1)
                        {
                            continue;
                        }
                        var values = info.Split(',');

                        if (values.Length != ItemsInRow)
                        {
                            throw new Exception($"Row {lineNum} contains {values.Length} values. It should contain {ItemsInRow}.");
                        }
                        try
                        {
                            int year              = int.Parse(values[0]);
                            int population        = int.Parse(values[1]);
                            int violentCrime      = int.Parse(values[2]);
                            int murder            = int.Parse(values[3]);
                            int rape              = int.Parse(values[4]);
                            int robbery           = int.Parse(values[5]);
                            int aggravatedAssault = int.Parse(values[6]);
                            int propertyCrime     = int.Parse(values[7]);
                            int burglary          = int.Parse(values[8]);
                            int theft             = int.Parse(values[9]);
                            int motorVehicleTheft = int.Parse(values[10]);



                            CrimeStats crimeStats = new CrimeStats(year, population, violentCrime, murder, rape, robbery, aggravatedAssault, propertyCrime, burglary, theft, motorVehicleTheft);
                            crimeStatsList.Add(crimeStats);
                        }
                        catch (FormatException e)
                        {
                            throw new Exception($"Row {lineNum} contains invalid data. ({e.Message})");
                        }
                    }
                }
            }
            catch (Exception e)
            {
                throw new Exception($"Unable to open {csvDataFilePath} ({e.Message}).");
            }

            return(crimeStatsList);
        }
示例#4
0
        private static bool ReadStats(string filePath)
        {
            try
            {
                int      column          = 0;
                string[] crimeStatsLines = File.ReadAllLines(filePath);

                for (int index = 0; index < crimeStatsLines.Length; index++)
                {
                    string   crimeStatsLine = crimeStatsLines[index];
                    string[] data           = crimeStatsLine.Split(',');

                    if (column != data.Length)
                    {
                        throw new Exception($"Invalid");
                    }
                    try
                    {
                        int        Year              = Int32.Parse(data[0]);
                        int        Population        = Int32.Parse(data[1]);
                        int        ViolentCrimes     = Int32.Parse(data[2]);
                        int        Murder            = Int32.Parse(data[3]);
                        int        Rape              = Int32.Parse(data[4]);
                        int        Robbery           = Int32.Parse(data[5]);
                        int        AggravatedAssault = Int32.Parse(data[6]);
                        int        PropertyCrime     = Int32.Parse(data[7]);
                        int        Burglary          = Int32.Parse(data[8]);
                        int        Theft             = Int32.Parse(data[9]);
                        int        MotorVehicleTheft = Int32.Parse(data[10]);
                        CrimeStats crimeStats        = new CrimeStats(Year, Population, ViolentCrimes, Murder, Rape, Robbery, AggravatedAssault, PropertyCrime, Burglary, Theft, MotorVehicleTheft);
                        CrimeStatsList.Add(crimeStats);
                    }
                    catch (InvalidCastException)
                    {
                        Console.WriteLine($"There is an invalid value.");
                        return(false);
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("An Error Occurred.");
                throw ex;
            }
            return(true);
        }
示例#5
0
        private static List <CrimeStats> ParseCrimeStatsList(IEnumerable <string> readLines, Dictionary <string, int> headerIndexes)
        {
            List <CrimeStats> crimeStatsList = new List <CrimeStats>();

            for (int i = 1; i < readLines.Count(); i++)
            {
                string readLine = readLines.ElementAt(i);
                try
                {
                    CrimeStats c = CrimeStats.BuildFromReadData(headerIndexes, readLine);
                    crimeStatsList.Add(c);
                }
                catch (Exception e)
                {
                    Console.WriteLine("Failed to build record from line {0} from input file.", i);
                    Console.WriteLine(e.Message);
                    Environment.Exit(1);
                }
            }

            return(crimeStatsList);
        }
示例#6
0
        public void linqWriting(string filePath)
        {
            try
            {
                if (crimeStatsList != null && crimeStatsList.Any())
                {
                    StringBuilder stringBuilder = new StringBuilder();
                    stringBuilder.Append("Crime Analyzer Report\n");

                    double minYear = crimeStatsList.Min(n => n.Year);
                    double maxYear = crimeStatsList.Max(n => n.Year);

                    double yearRange = maxYear - minYear + 1;
                    stringBuilder.Append("Period: {minYear}-{maxYear} ({yearRange} years)\n");


                    var numberOfYears = from crimeStat in crimeStatsList
                                        select crimeStat.Year;

                    stringBuilder.Append("Years murders per year: {mYearsStr}\n");

                    var yearsWhereMurdersWereLessThan15000 = from crimeStat in crimeStatsList
                                                             where crimeStat.Murders < 15000
                                                             select crimeStat.Year;
                    stringBuilder.Append("Years murders per year < 15000: {yearsWhereMurdersWereLessThan15000}\n");

                    var aWholeLotOfRobberies = from crimeStat in crimeStatsList
                                               where crimeStat.Robberies > 500000
                                               select crimeStat;


                    string robberiesYears = null;
                    for (int i = 0; i < aWholeLotOfRobberies.Count(); i++)
                    {
                        CrimeStats crimeStats = aWholeLotOfRobberies.ElementAt(i);
                        robberiesYears += "{crimeStats.Year} = {crimeStats.Robberies}";
                        if (i < aWholeLotOfRobberies.Count() - 1)
                        {
                            robberiesYears += ", ";
                        }
                    }
                    stringBuilder.Append("Robberies per year > 500000: {robberiesYears}\n");

                    var violentCrime = from crimeStats in crimeStatsList
                                       where crimeStats.Year == 2010
                                       select crimeStats;

                    CrimeStats violentCrimeData      = violentCrime.First();
                    double     violentCrimePerCapita = (double)violentCrimeData.ViolentCrimes / (double)violentCrimeData.Population;
                    stringBuilder.Append("Violent crime per capita rate (2010): {violentCrimePerCapita}\n");

                    double avgMurders = crimeStatsList.Sum(n => n.Murders) / crimeStatsList.Count;
                    stringBuilder.Append("Average murder per year (all years): {avgMurders}\n");

                    double murders1 = crimeStatsList
                                      .Where(n => n.Year >= 1994 && n.Year <= 1997)
                                      .Sum(y => y.Murders);
                    double avgMurders1 = murders1 / crimeStatsList.Count;
                    stringBuilder.Append("Average murder per year (1994-1997): {avgMurders1}\n");

                    double murders2 = crimeStatsList
                                      .Where(n => n.Year >= 2010 && n.Year <= 2014)
                                      .Sum(y => y.Murders);

                    double avgMurders2 = murders2 / crimeStatsList.Count;
                    stringBuilder.Append("Average murder per year (2010-2014): {avgMurders2}\n");

                    double minTheft = crimeStatsList
                                      .Where(n => n.Year >= 1999 && n.Year <= 2004)
                                      .Min(n => n.Thefts);
                    stringBuilder.Append("Minimum thefts per year (1999-2004): {minTheft}\n");

                    double maxTheft = crimeStatsList
                                      .Where(n => n.Year >= 1999 && n.Year <= 2004)
                                      .Max(n => n.Thefts);
                    stringBuilder.Append("Maximum thefts per year (1999-2004): {maxTheft}\n");

                    double maxVehicleTheft = crimeStatsList.OrderByDescending(n => n.MotorVehicleThefts).First().Year;
                    stringBuilder.Append("Year of highest number of motor vehicle thefts: {maxVehicleTheft}\n");

                    using (var stream = new StreamWriter(filePath))
                    {
                        stream.Write(stringBuilder);
                    }
                    Console.WriteLine("Written report successfully.");
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("Error in writing report file.");
                throw e;
            }
        }
示例#7
0
        static void Main(string[] args)
        {
            Console.WriteLine("Welcom to the Crime Analyzer");
            Console.WriteLine("\n");
            Console.WriteLine("This program will analyze crime statistics.");

            if (args.Length >= 2)
            {
                string reportFile = args[1];
                var    csvFile    = args[0];

                try
                {
                    using (var sr = new StreamReader(csvFile))
                    {
                        List <string> years          = new List <string>();
                        List <string> populations    = new List <string>();
                        List <string> violentCrimes  = new List <string>();
                        List <string> murders        = new List <string>();
                        List <string> rapes          = new List <string>();
                        List <string> robberies      = new List <string>();
                        List <string> aggAssaults    = new List <string>();
                        List <string> propertyCrimes = new List <string>();
                        List <string> burglaries     = new List <string>();
                        List <string> thefts         = new List <string>();
                        List <string> mvts           = new List <string>();


                        while (!sr.EndOfStream)
                        {
                            var line   = sr.ReadLine();
                            var values = line.Split(',');

                            int        year              = Int32.Parse(values[0]);
                            int        population        = Int32.Parse(values[1]);
                            int        violentCrime      = Int32.Parse(values[2]);
                            int        murder            = Int32.Parse(values[3]);
                            int        rape              = Int32.Parse(values[4]);
                            int        robbery           = Int32.Parse(values[5]);
                            int        aggravatedAssault = Int32.Parse(values[6]);
                            int        propertyCrime     = Int32.Parse(values[7]);
                            int        burglary          = Int32.Parse(values[8]);
                            int        theft             = Int32.Parse(values[9]);
                            int        mvt        = Int32.Parse(values[10]);
                            CrimeStats crimeStats = new CrimeStats(year, population, violentCrime, murder, rape, robbery, aggravatedAssault, propertyCrime, burglary, theft, mvt);


                            IEnumerable <string> yearQuery =
                                from year1 in years
                                where murder < 15000
                                select year1;
                            foreach (string year1 in yearQuery)
                            {
                                Console.WriteLine("year" + "");
                            }
                        }
                        //First Question
                        string minYear = years[1];
                        string maxYear = years.Last() :

                                             StringBuilder newString = new StringBuilder();
                        newString.Append("Your Crime Analyzer Report");
                        newString.Append(Environment.NewLine);
                        newString.Append(Environment.NewLine);
                        newString.Append("Time Period: " + minYear + "-" + maxYear);

                        using (var stream = new StreamWriter(reportFile))
                        {
                            stream.Write(newString.ToString());
                            Console.WriteLine(newString.ToString());
                        }
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine("Exception: " + e.Message);
                }
            }
            else
            {
                Console.WriteLine("You must give 2 arguments: .csv file and report file.");
            }
        }
示例#8
0
 internal static void Add(CrimeStats CrimeStats)
 {
     throw new NotImplementedException();
 }
示例#9
0
        public static void Main(string[] args)
        {
            string line;

            try
            {
                List <CrimeStats> crimeStatsList = new List <CrimeStats>();


                //Console.WriteLine("Enter the File name:");
                /// string filename = Console.ReadLine();

                string filename = args[0];  // csv file

                //Console.WriteLine("Enter the report filename:");
                // string report = Console.ReadLine();

                string report = args[1]; // report file

                StreamWriter sw = new  StreamWriter(report);



                StreamReader sr = new StreamReader(filename);

                /// read first line
                line = sr.ReadLine();


                // Second line where data starts
                line = sr.ReadLine();

                while (line != null)
                {
                    string[] columns = line.Split(',');  // columns[0] == year columns[1] == population columns[2] == Violent Crime


                    int year              = Convert.ToInt32(columns[0]);
                    int population        = Convert.ToInt32(columns[1]);
                    int violentCrime      = Convert.ToInt32(columns[2]);
                    int murder            = Convert.ToInt32(columns[3]);
                    int rape              = Convert.ToInt32(columns[4]);
                    int robbery           = Convert.ToInt32(columns[5]);
                    int aggravatedAssault = Convert.ToInt32(columns[6]);
                    int propertyCrime     = Convert.ToInt32(columns[7]);
                    int burglary          = Convert.ToInt32(columns[8]);
                    int theft             = Convert.ToInt32(columns[9]);
                    int motorVehicleTheft = Convert.ToInt32(columns[10]);

                    // Read next line
                    line = sr.ReadLine();

                    CrimeStats crimeStats = new CrimeStats(year, population, violentCrime, murder, rape, robbery, aggravatedAssault, propertyCrime, burglary, theft, motorVehicleTheft);

                    crimeStatsList.Add(crimeStats);
                }

                // What is the range of years included in the data?
                IEnumerable <int> q1 = from crimeStats in crimeStatsList
                                       where crimeStats.year >= 1994 && crimeStats.year < 2014
                                       select crimeStats.year;

                Console.WriteLine($"Period {q1.Min()} - {q1.Max()}  ({q1.Max() - q1.Min()} years)");
                sw.WriteLine($"Period {q1.Min()} - {q1.Max()}  ({q1.Max() - q1.Min()} years)");



                // How many years of data are included?
                IEnumerable <int> q2 = from crimeStats in crimeStatsList
                                       select crimeStats.year;

                Console.WriteLine($"Year count {q2.Count()}");
                sw.WriteLine($"Year count {q2.Count()}");


                // What years is the number of murders per year less than 15000?
                IEnumerable <int> q3 = from crimeStats in crimeStatsList
                                       where crimeStats.murder < 15000
                                       select crimeStats.year;

                Console.Write($"Years murders per year< 15000: ");
                sw.Write($"Years murders per year< 15000: ");


                foreach (int x in q3)
                {
                    Console.Write($"{x}, ");
                    sw.Write($"{x}, ");
                }

                Console.WriteLine("\n");
                sw.WriteLine("\n");


                // What are the years and associated robberies per year for years where the number of robberies is greater than 500000 ?
                IEnumerable <int> q4 = from crimeStats in crimeStatsList
                                       where crimeStats.robbery > 500000
                                       select crimeStats.year;

                Console.Write("Robberies per year > 500000 ");
                sw.Write("Robberies per year > 500000 ");


                foreach (int x in q4)
                {
                    Console.Write($"{x}, ");
                    sw.Write($"{x}, ");
                }

                Console.WriteLine("\n");
                sw.WriteLine("\n");



                // What is the violent crime per capita rate for 2010? Per capita rate is the number of violent crimes in a year divided by the size of the population that year.

                IEnumerable <double> q5 = from crimeStats in crimeStatsList
                                          where crimeStats.year == 2010
                                          select crimeStats.violentCrime / (double)crimeStats.population;


                Console.Write("Violent crime per capita rate(2010): ");
                sw.Write("Violent crime per capita rate(2010): ");

                foreach (double x in q5)
                {
                    Console.Write(x);
                    sw.Write(x);
                }
                Console.WriteLine("\n");
                sw.WriteLine("\n");


                // What is the average number of murders per year across all years?
                IEnumerable <int> q6 = from crimeStats in crimeStatsList
                                       select crimeStats.murder;


                double avg_murder = q6.Average();
                Console.WriteLine($"Average murder per year (all years):  {avg_murder}");
                sw.WriteLine($"Average murder per year (all years):  {avg_murder}");



                // What is the average number of murders per year for 1994 to 1997?
                IEnumerable <int> q7 = from crimeStats in crimeStatsList
                                       where crimeStats.year >= 1994 && crimeStats.year <= 1997
                                       select crimeStats.murder;

                double avg_murder2 = q7.Average();
                Console.WriteLine($"Average murder per year (1994-1997) {avg_murder2}");
                sw.WriteLine($"Average murder per year (1994-1997) {avg_murder2}");


                // What is the average number of murders per year for 2010 to 2013?
                IEnumerable <int> q8 = from crimeStats in crimeStatsList
                                       where crimeStats.year >= 2010 && crimeStats.year <= 2013
                                       select crimeStats.murder;

                double avg_murder3 = q8.Average();
                Console.WriteLine($"Average murder per year (2010-2013) {avg_murder3}");
                sw.WriteLine($"Average murder per year (2010-2013) {avg_murder3}");


                // What is the minimum number of thefts per year for 1999 to 2004?
                IEnumerable <int> q9 = from crimeStats in crimeStatsList
                                       where crimeStats.year >= 1999 && crimeStats.year <= 2004
                                       select crimeStats.theft;


                Console.WriteLine($"Minimum thefts per year (1999-2004): {q9.Min()}");
                sw.WriteLine($"Minimum thefts per year (1999-2004): {q9.Min()}");



                // QUESTION 10  What is the maximum number of thefts per year for 1999 to 2004 ?
                Console.WriteLine($"Maximum thefts per year (1999-2004): {q9.Max()}");
                sw.WriteLine($"Maximum thefts per year (1999-2004): {q9.Max()}");


                // What year had the highest number of motor vehicle thefts?


                IEnumerable <int> q11 = from crimeStats in crimeStatsList
                                        where crimeStats.motorVehicleTheft > 1
                                        select crimeStats.motorVehicleTheft;



                int highest_murder = q11.Max();

                // get year
                IEnumerable <int> q11_1 = from crimeStats in crimeStatsList
                                          where crimeStats.motorVehicleTheft == highest_murder
                                          select crimeStats.year;

                foreach (int x in q11_1)
                {
                    sw.WriteLine($"Year of highest number of motor vehicle thefts {x}");
                    break;
                }



                sr.Close();
                sw.Close();
            }

            catch (Exception e)
            {
                Console.WriteLine("Exception:" + e.Message);
            }

            finally
            {
                Console.WriteLine("final block");
            }
        }
示例#10
0
        static void GenerateCrimeReport(List <CrimeStats> CrimeStatsList, string filePath)
        {
            if (CrimeStatsList.Count == 0)
            {
                throw new CrimeReportEmptyDataException("Data provided for the Crime Report is empty. Please check your CSV file.");
            }

            StreamWriter sw = null;

            try {
                sw = new StreamWriter(filePath);

                sw.WriteLine("+= Crime Analyzer Report =+\n");

                IEnumerable <int> years = from CrimeStats in CrimeStatsList select CrimeStats.Year;
                int start = years.Min();
                int end   = years.Max();
                int span  = end - start + 1;
                sw.WriteLine("Period: {0}-{1} ({2} year{3})\n", start, end, span, span > 1 ? "s" : "");

                string            csv         = "";
                int               index       = 0;
                IEnumerable <int> murderYears = from CrimeStats in CrimeStatsList where CrimeStats.Murder < 15000 select CrimeStats.Year;
                foreach (int year in murderYears)
                {
                    csv += string.Format("{0}{1}", year, index < (murderYears.Count() - 1) ? ", " : "");
                    ++index;
                }
                sw.WriteLine("Years murders per year < 15000: {0}", csv);

                csv   = "";
                index = 0;
                IEnumerable <CrimeStats> robberyStats = from CrimeStats in CrimeStatsList where CrimeStats.Robbery > 500000 select CrimeStats;
                foreach (CrimeStats stats in robberyStats)
                {
                    csv += string.Format("{0} = {1}{2}", stats.Year, stats.Robbery, index < (robberyStats.Count() - 1) ? ", " : "");
                    ++index;
                }
                sw.WriteLine("Robberies per year > 500000: {0}", csv);

                CrimeStats cpcYear = (from CrimeStats in CrimeStatsList where CrimeStats.Year == 2010 select CrimeStats).FirstOrDefault();
                string     cpcText = cpcYear == null ? "No data to calculate crime per capita in 2010" : ((double)cpcYear.ViolentCrime / cpcYear.Population).ToString();
                sw.WriteLine("Violent crime per capita rate (2010): {0}", cpcText);

                double averageMurders = (from CrimeStats in CrimeStatsList select CrimeStats.Murder).Average();
                sw.WriteLine("Average murders per year (all years): {0}", averageMurders);

                averageMurders = (from CrimeStats in CrimeStatsList where (CrimeStats.Year >= 1994 && CrimeStats.Year <= 1997) select CrimeStats.Murder).Average();
                sw.WriteLine("Average murders per year (1994-1997): {0}", averageMurders);

                averageMurders = (from CrimeStats in CrimeStatsList where (CrimeStats.Year >= 2010 && CrimeStats.Year <= 2014) select CrimeStats.Murder).Average();
                sw.WriteLine("Average murders per year (2010-2014): {0}", averageMurders);

                IEnumerable <int> thefts = (from CrimeStats in CrimeStatsList where (CrimeStats.Year >= 1999 && CrimeStats.Year <= 2004) select CrimeStats.Theft);
                sw.WriteLine("Minimum Therfts per year (1999-2004): {0}", thefts.Min());
                sw.WriteLine("Maximum Therfts per year (1999-2004): {0}", thefts.Max());

                int maxMotorTheftsYear = (from CrimeStats in CrimeStatsList let maxMotorTheft = CrimeStatsList.Max(stats => stats.MotorVehicleTheft) where CrimeStats.MotorVehicleTheft == maxMotorTheft select CrimeStats.Year).FirstOrDefault();

                sw.WriteLine("Year with the highest number of Motor Vehicle thefts: {0}", maxMotorTheftsYear);
            } catch (Exception e) {
                if (e is UnauthorizedAccessException || e is ArgumentException || e is DirectoryNotFoundException || e is PathTooLongException || e is IOException)
                {
                    throw new CrimeReportFileWriteException(string.Format("File at \"{0}\" is incorrect.\nPath either does not exist or is formatted incorrectly.\nPlease try again.", filePath));
                }
                else
                {
                    throw e;
                }
            } finally {
                if (sw != null)
                {
                    sw.Close();
                }
            }
        }
示例#11
0
        private static void WriteReport(string filePath)
        {
            try
            {
                if (CrimeStatsList != null && CrimeStatsList.Any())
                {
                    StringBuilder newString = new StringBuilder();

                    newString.Append("Crime Analyzer Report\n\n");

                    int minYear = CrimeStatsList.Min(x => x.Year);
                    int maxYear = CrimeStatsList.Max(x => x.Year);

                    int years = maxYear - minYear + 1;

                    newString.Append($"Period: { minYear}-{ maxYear} ({ years} years\n\n");

                    var totalYears = from crimeStats in CrimeStatsList
                                     where crimeStats.Murder < 15000
                                     select crimeStats.Year;

                    string totalYearsStr = string.Empty;

                    for (int i = 0; i < totalYears.Count(); i++)
                    {
                        totalYearsStr += totalYears.ElementAt(i).ToString();

                        if (i < totalYears.Count() - 1)
                        {
                            totalYearsStr += ", ";
                        }
                    }

                    newString.Append($"Years murders per year < 15000: { totalYearsStr}\n");

                    var robYears = from crimeStats in CrimeStatsList
                                   where crimeStats.Robbery > 500000
                                   select crimeStats;

                    string robYearsStr = string.Empty;

                    for (int i = 0; i < robYears.Count(); i++)
                    {
                        CrimeStats crimeStats = robYears.ElementAt(i);

                        robYearsStr += $"{ crimeStats.Year} = { crimeStats.Robbery}";

                        if (i < robYears.Count() - 1)
                        {
                            robYearsStr += ", ";
                        }
                    }

                    newString.Append($"Robberies per year > 500000: { robYearsStr}\n");

                    var violentCrime = from crimeStats in CrimeStatsList
                                       where crimeStats.Year == 2010
                                       select crimeStats;

                    CrimeStats violentCrimeStats = violentCrime.First();

                    double violentCrimePerCapita = (double)violentCrimeStats.ViolentCrimes / (double)violentCrimeStats.Population;

                    double avgMurders = (float)CrimeStatsList.Sum(x => x.Murder) / (float)CrimeStatsList.Count;

                    newString.Append($"Average murder per year (all years): { avgMurders}\n");

                    int murd = CrimeStatsList.Where(x => x.Year >= 2010 && x.Year <= 2014).Sum(y => y.Murder);

                    double avgMurd = (float)murd / 5;

                    newString.Append($"Average murder per year (2010-2014): { avgMurd}\n");

                    int minTheft = CrimeStatsList.Where(x => x.Year >= 1999 && x.Year <= 2004).Min(x => x.Theft);

                    newString.Append($"Minimum thefts per year (1999-2004): { minTheft}\n");

                    int maxTheft = CrimeStatsList.Where(x => x.Year >= 1999 && x.Year <= 2004).Max(x => x.Theft);

                    newString.Append($"Maximum thefts per year (1999-2004): { maxTheft}\n");

                    int maxVehicleTheft = CrimeStatsList.OrderByDescending(x => x.MotorVehicleTheft).First().Year;

                    newString.Append($"Year of highest number of motor vehicle thefts: { maxVehicleTheft}\n");

                    using (var stream = new StreamWriter(filePath))
                    {
                        stream.Write(newString.ToString());
                    }

                    Console.WriteLine();
                    Console.WriteLine(newString.ToString());
                    Console.WriteLine(); 

                }
                
 else
                {
                    
 Console.WriteLine($"No Data."); 

                } 

            } 
            catch (Exception ex) 
            {
                    
 Console.WriteLine("Error."); 
                throw ex; 

                }
        }