Squirrel to organize books

bookOrg.cs

   Table books = DataAcquisition.LoadCSV(@"C:\personal\books.csv");
            //genre,author,height-genre*author
            books.AddColumn("GenreAsNum", books.ValuesOf("Genre"));
            books.Transform("GenreAsNum", x => x == "fiction" ? "1" : x == "nonfiction" ?
                         "2" : x == "philosophy" ?
                         "3" : x == "science" ?
                         "4" : x == "tech" ?
                         "5" :
                         "-1");
            books = books.Transform("Author", x =>
            {
                if (x.Contains(',')) return x.Substring(0, x.IndexOf(','));
                else if (x.Contains(' ')) return x.Substring(0, x.IndexOf(' ')); else return x;
            });


            books.AddColumn("Shelf", "Floor([Height]/[GenreAsNum])", 0);

            int max = books.ValuesOf("Shelf").Select(t => Convert.ToInt32(t)).Max();

            books.Transform("Shelf", x => Math.Ceiling((6 * Convert.ToDecimal(Convert.ToDouble(x) / Convert.ToDouble(max)))).ToString());




            var shelfs = books.SortBy("Height").ThenBy("Author").ThenBy("Genre").SplitOn("Shelf");

            string html = shelfs.Select( t => t.Value.Pick("Title", "Author", "Genre", "Height")
                              .ToHTMLTable())
                  .Aggregate((a,b)=> a + " <h2>New Book Shelf</h2>" + b);