Port of the C# 101 LINQ Samples rewritten into modern C# syntax and then also using Python, using built in methods where possible.
Python doesn't really lend itself well to functional programming because is functional methods are really procedural. There is support for lambda expressions, but you can't chain or compose your your functional operations very well as you will see compare to C# equivalent below.
Source for both C# and Python are included in the src folder in this repository
- To run the respective C# projects (.csproj), open the containing folder in Visual Studio Code use the Debug command
- To run the respective Python files (.py), open the file in Visual Studio Code use the Run Python File in Terminal right click menu command (requirses the Python extension)
| Operation | C# | python | Comment |
|---|---|---|---|
| Filter | Where |
(x for x in sequence if fiter(x)) |
Can also use filter(f(x), sequence) |
| Projection | Select |
(f(x) for x in sequence) |
Can also use map(f(x), sequence) |
SelectMany |
(f(x, y) for x in sequence1 for y in sequence2) |
||
| Partitioning | Take(n) |
array[:n] |
|
TakeWhile(predicate) |
takewhile(predicate) |
from itertools import takewhile |
|
Skip(n) |
array[n:] |
||
SkipWhile(predicate) |
dropwhile(predicate, sequence) |
from itertools import dropwhile |
|
| Ordering | OrderBy |
sequence.sort() or sorted(sequence) |
|
OrderBy(lambda) |
sequence.sort(key=lambda) or sorted(sequence, key=lambda) |
||
OrderByDescending |
sequence.sort(reverse=True) or sorted(sequence, reverse=True) |
||
OrderByDescending(lambda) |
sequence.sort(key=lambda, reverse=True) or sorted(sequence, key=lambda, reverse=True) |
||
ThenBy |
sequence.sort(key=lambda (key1, key2)) or sorted(sequence, key=lambda (key1, key)) |
||
ThenByDescending |
sequence.sort(key=lambda (key1, -key2)) or sorted(sequence, key=lambda (key1, -key2)) or use a 2 pass sort, starting with least significant ordered = sorted(unordered, key=lambda (key2)) ordered = sorted(ordered, key=lambda (key1)) |
||
Reverse |
sequence.reverse() or reversed(sequence) |
||
| Grouping | GroupBy |
groupby |
from itertools. import groupbyGrouping works on sorted sequences Once you've iterated over the grouping, you can't access it again, its empty |
| Sets | Distinct |
set |
or Set comprehension {x for x in sequence} |
Union |
union |
||
Interect |
intersection |
||
Except |
difference |
||
| Conversion | ToArray |
list |
|
ToList |
list |
||
ToDictionary |
{key:value for (key,value) in sequence} |
or use dict in conjuction with zip |
|
OfType |
'filter using isinstance as predicate |
||
| Element | First |
next |
|
First(lambda) |
next(list) |
next(filter(lambda) |
|
FirstOrDefault |
next(list) |
next(filter(lambda), default) |
|
ElementAt |
list[0] |
||
| Generation | Enumerable.Range |
range | |
Enumerable.Repeat |
[x] * n or repeat(x, n) |
from itertools import repeat |
|
| Quantifiers | Any |
any |
|
All |
all |
||
| Aggregate | Count |
len |
|
Count(lamda) |
sum(1, iterator) |
||
Sum |
sum |
||
Min |
min |
||
Max |
max |
||
Avg |
Custom calculation using sum / len |
||
Sum(lambda) |
sum(iterator) |
||
Min(lambda) |
min(iterator) |
||
Max(lambda) |
max(iterator) |
||
Avg(lambda) |
Custom calculation using sum(iterator) / len |
||
Aggregate |
reduce(lambda, sequence) |
from functools import reduce |
|
Aggregate(seed, lamda) |
reduce(lambsa,seed,sequence) |
from functools import reduce |
|
| Miscellaneous | Concat(IEnumerable) |
list1 + list2 |
|
SequenceEqual(IEnumerable) |
list1==list2 |
For a side-by-side comparison, the original C# source code is displayed above the equivalent python translation.
- The Output shows the console output of running the python sample.
- Outputs ending with
...illustrates only a partial response is displayed. - The source-code for C# and python utils used are included once under the first section they're used in.
- The C# ObjectDumper util used is downloadable from MSDN - ObjectDumper.zip
- Where I haven't been able to figure out the Python implemention, I've created an empty function like this:
def f:
passThis sample uses a filter to find all elements of an array with a value less than 5.
//c#
static void Linq1()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var lowNums = numbers.Where(n => n < 5);
Console.WriteLine("Numbers < 5:");
lowNums.ForEach(Console.WriteLine);
}#python
def linq1():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
low_nums = (x for x in numbers if x < 5)
print("Numbers < 5:")
shared.printN(low_nums)Numbers < 5:
4
1
3
2
0
This sample uses a filter to find all products that are out of stock.
//c#
static void Linq2()
{
var products = GetProductList();
var soldOutProducts = products.Where(p => p.UnitsInStock == 0);
Console.WriteLine("Sold out products:");
soldOutProducts.ForEach(x => Console.WriteLine($"{x.ProductName} is sold out!"));
}#python
def linq2():
products = shared.getProductList()
sold_out_products = (x for x in products if x.UnitsInStock == 0)
print("Sold out products:")
for item in sold_out_products:
print("%s is sold out!" % item.ProductName)Sold out products:
Chef Anton's Gumbo Mix is sold out!
Alice Mutton is sold out!
Th�ringer Rostbratwurst is sold out!
Gorgonzola Telino is sold out!
Perth Pasties is sold out!
This sample uses a filter to find all products that are in stock and cost more than 3.00 per unit.
//c#
public static void Linq3()
{
var products = GetProductList();
var expensiveInStockProducts = products.Where(p => p.UnitsInStock > 0 && p.UnitPrice > 3.00M);
Console.WriteLine("In-stock products that cost more than 3.00:");
expensiveInStockProducts.ForEach(product => Console.WriteLine($"{product.ProductName} is in stock and costs more than 3.00."));
}#python
def linq3():
products = shared.getProductList()
expensive_in_stock_products = (x for x in products if x.UnitsInStock > 0 and x.UnitPrice > 3.0000)
print("In-stock products that cost more than 3.00:")
for item in expensive_in_stock_products:
print("%s is in stock and costs more than 3.00." % item.ProductName)In-stock products that cost more than 3.00:
Chai is in stock and costs more than 3.00.
Chang is in stock and costs more than 3.00.
Aniseed Syrup is in stock and costs more than 3.00.
...
This sample uses a filter to find all customers in Washington and then it uses a foreach loop to iterate over the orders collection that belongs to each customer.
//c#
static void Linq4()
{
var customers = GetCustomerList();
Console.WriteLine("Customers from Washington and their orders:");
var waCustomers = customers.Where(c => c.Region == "WA");
waCustomers.ForEach((customer) =>
{
Console.WriteLine($"Customer {customer.CustomerID}: {customer.CompanyName}");
customer.Orders.ForEach((order) =>
{
Console.WriteLine($" Order {order.OrderID}: {order.OrderDate}");
});
});
}#python
def linq4():
customers = shared.getCustomerList()
wa_customers = (x for x in customers if x.Region == "WA")
print("Customers from Washington and their orders:")
for customer in wa_customers:
print("Customer %s : %s" % (customer.CustomerID, customer.CompanyName))
for order in customer.Orders:
print(" Order %s: %s" % (order.OrderID, order.OrderDate))Customers from Washington and their orders:
Customer LAZYK: Lazy K Kountry Store
Order 10482: 1997-03-21T00:00:00
Order 10545: 1997-05-22T00:00:00
Customer TRAIH: Trail's Head Gourmet Provisioners
Order 10574: 1997-06-19T00:00:00
Order 10577: 1997-06-23T00:00:00
Order 10822: 1998-01-08T00:00:00
...
This sample demonstrates an indexed filter that returns digits whose name is shorter than their value.
//c#
static void Linq5()
{
var digits = new[] { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var shortDigits = digits.Where((digit, index) => digit.Length < index);
Console.WriteLine("Short digits:");
shortDigits.ForEach(d => Console.WriteLine($"The word {d} is shorter than its value."));
}#python
def linq5():
digits = ["zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]
index = 0
# Lambdas cant have multiple lines, so create a filter function
def filter_func(digit):
nonlocal index
result = len(digit) < index
index += 1
return result
short_digits = filter(filter_func, digits)
print("Short digits:")
for d in short_digits:
print("The word %s is shorter than its value." % d)Short digits:
The word five is shorter than its value.
The word six is shorter than its value.
The word seven is shorter than its value.
The word eight is shorter than its value.
The word nine is shorter than its value.
This sample projects a sequence of ints 1+ higher than those in an existing array of ints.
//c#
static void Linq6()
{
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var numsPlusOne = numbers.Select(n => n + 1);
Console.WriteLine("Numbers + 1:");
numsPlusOne.ForEach(Console.WriteLine);
}#python
def linq6():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
nums_plus_one = (n+1 for n in numbers)
print("Numbers + 1:")
shared.printN(nums_plus_one)Numbers + 1:
6
5
2
4
10
9
7
8
3
1
This sample projects a sequence of just the names of a list of products.
//c#
static void Linq7()
{
var products = GetProductList();
var productNames = products.Select(p => p.ProductName);
Console.WriteLine("Product Names:");
productNames.ForEach(Console.WriteLine);
}#python
def linq7():
products = shared.getProductList()
product_names = (p.ProductName for p in products)
print("Product Names:")
shared.printS(product_names)Product Names:
Chai
Chang
Aniseed Syrup
Chef Anton's Cajun Seasoning
Chef Anton's Gumbo Mix
...
This sample projects a sequence of strings representing the text version of a sequence of integers.
//c#
static void Linq8()
{
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var strings = new [] { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var textNums = numbers.Select(n => strings[n]);
Console.WriteLine("Number strings:");
textNums.ForEach(Console.WriteLine);
}#python
def linq8():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
strings = ["zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]
text_nums = (strings[n] for n in numbers)
print("Number strings:")
shared.printS(text_nums)Number strings:
five
four
one
three
nine
eight
six
seven
two
zero
"This sample projects a sequence of the uppercase and lowercase versions of each word in the original array.
//c#
static void Linq9()
{
var words = new[] { "aPPLE", "BlUeBeRrY", "cHeRry" };
var upperLowerWords = words.Select(w =>
new
{
Upper = w.ToUpper(),
Lower = w.ToLower()
});
upperLowerWords.ForEach(ul => Console.WriteLine($"Uppercase: {ul.Upper}, Lowercase: {ul.Lower}"));
}#python
def linq9():
words = ["aPPLE", "BlUeBeRrY", "cHeRry"]
upper_lower_words = (SimpleNamespace(Upper=w.upper(),
Lower=w.lower())
for w in words)
for word in upper_lower_words:
print("Uppercase: %s, Lowercase: %s" % (word.Upper, word.Lower))Uppercase: APPLE, Lowercase: apple
Uppercase: BLUEBERRY, Lowercase: blueberry
Uppercase: CHERRY, Lowercase: cherry
This sample projects a sequence containing text representations of digits and whether their length is even or odd.
//c#
static void Linq10()
{
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var strings = new[] { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var digitOddEvens = numbers.Select(n =>
new
{
Digit = strings[n],
Even = (n % 2 == 0)
});
digitOddEvens.ForEach(d => Console.WriteLine($"The digit {d.Digit} is {(d.Even ? "even" : "odd")}."));
}#python
def linq10():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
strings = ["zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]
digit_odd_evens = (SimpleNamespace(Digit=strings[n],
Even=(n % 2 == 0))
for n in numbers)
for d in digit_odd_evens:
print("The digit %s is %s" % (d.Digit, 'even' if d.Even else 'odd'))The digit five is odd.
The digit four is even.
The digit one is odd.
The digit three is odd.
The digit nine is odd.
The digit eight is even.
The digit six is even.
The digit seven is odd.
The digit two is even.
The digit zero is even.
This sample projects a sequence containing some properties of Products, including UnitPrice which is renamed to Price in the resulting type.
//c#
static void Linq11()
{
var products = GetProductList();
var productInfos = products.Select(p =>
new
{
p.ProductName,
p.Category,
Price = p.UnitPrice
});
Console.WriteLine("Product Info:");
productInfos.ForEach(productInfo => Console.WriteLine($"{productInfo.ProductName} is in the category {productInfo.Category} and costs {productInfo.Price} per unit."));
}#python
def linq11():
products = shared.getProductList()
product_info = (SimpleNamespace(ProductName=p.ProductName,
Category=p.Category,
Price=p.UnitPrice)
for p in products)
print("Product Info:")
for product in product_info:
print("%s is in the category %s and costs %.2f per unit." % (product.ProductName, product.Category, product.Price))Product Info:
Chai is in the category Beverages and costs 18.0 per unit.
Chang is in the category Beverages and costs 19.0 per unit.
Aniseed Syrup is in the category Condiments and costs 10.0 per unit.
...
This sample uses an indexed projection to determine if the value of integers in an array match their position in the array.
//c#
static void Linq12()
{
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var numsInPlace = numbers.Select((num, index) =>
new
{
Num = num,
InPlace = (num == index)
});
Console.WriteLine("Number: In-place?");
numsInPlace.ForEach(n => Console.WriteLine($"{n.Num}: {n.InPlace}"));
}#python
def linq12():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
index = 0
def digit_equals_index(digit):
nonlocal index
result = digit == index
index += 1
return result
nums_in_place = (SimpleNamespace(Num=num,
InPlace=digit_equals_index(num))
for num in numbers)
print("Number: In-place?")
for n in nums_in_place:
print("%d: %s" % (n.Num, n.InPlace))Number: In-place?
5: False
4: False
1: False
3: True
9: False
8: False
6: True
7: True
2: False
0: False
This sample first filters, then projects to make a simple query that returns the text form of each digit less than 5.
//c#
static void Linq13()
{
var numbers = new []{ 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var digits = new [] { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var lowNums = numbers
.Where(n => n < 5)
.Select(n => digits[n]);
Console.WriteLine("Numbers < 5:");
lowNums.ForEach(Console.WriteLine);
}#python
def linq13():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
digits = ["zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]
result = (digits[n] for n in numbers if n < 5)
print("Numbers < 5:")
shared.printS(result)Numbers < 5:
four
one
three
two
zero
This sample projects a combination of 2 source arrays, then filters all pairs of numbers from both arrays such that the number from numbersA is less than the number from numbersB.
//c#
static void Linq14()
{
var numbersA = new [] { 0, 2, 4, 5, 6, 8, 9 };
var numbersB = new []{ 1, 3, 5, 7, 8 };
var pairs = numbersA
.SelectMany(a => numbersB, (a, b) => new { a, b })
.Where(x => x.a < x.b);
Console.WriteLine("Pairs where a < b:");
pairs.ForEach(pair => Console.WriteLine("{0} is less than {1}", pair.a, pair.b));
}#python
def linq14():
numbers_a = [0, 2, 4, 5, 6, 8, 9]
numbers_b = [1, 3, 5, 7, 8]
pairs = ((a, b) for a in numbers_a for b in numbers_b if (a < b))
print("Pairs where a < b:")
for p in pairs:
print("%d is less than %d" % (p[0], p[1]))Pairs where a < b:
0 is less than 1
0 is less than 3
0 is less than 5
0 is less than 7
0 is less than 8
2 is less than 3
2 is less than 5
2 is less than 7
2 is less than 8
4 is less than 5
4 is less than 7
4 is less than 8
5 is less than 7
5 is less than 8
6 is less than 7
6 is less than 8
TThis sample uses a nested projection to flatten the customer orders, then filtes the order total is less than 500.00.
//c#
static void Linq15()
{
var customers = GetCustomerList();
var orders = customers
.SelectMany(customer => customer.Orders, (customer, order) => new { customer, order })
.Where(x => x.order.Total < 500.00M)
.Select(x =>
new
{
x.customer.CustomerID,
x.order.OrderID,
x.order.Total
});
ObjectDumper.Write(orders);
}#python
def linq15():
customers = shared.getCustomerList()
orders_less_than_500 = ((customer, order)
for customer in customers
for order in customer.Orders
if order.Total < 500.00)
orders = (SimpleNamespace(customer_id=x[0].CustomerID,
order_id=x[1].OrderID,
total=x[1].Total)
for x in orders_less_than_500)
shared.print_namespace(orders){CustomerId: ALFKI, OrderId: 10702, Total: 330.0}
{CustomerId: ALFKI, OrderId: 10952, Total: 471.2}
{CustomerId: ANATR, OrderId: 10308, Total: 88.8}
{CustomerId: ANATR, OrderId: 10625, Total: 479.75}
...
This sample uses a nested projection to flatten the customer orders, the filters all orders that was made in 1998 or later.
//c#
static void Linq16()
{
var customers = GetCustomerList();
var orders = customers
.SelectMany(customer => customer.Orders, (customer, order) => new { customer, order })
.Where(x => x.order.OrderDate >= new DateTime(1998, 1, 1))
.Select(x =>
new
{
x.customer.CustomerID,
x.order.OrderID,
x.order.OrderDate
});
ObjectDumper.Write(orders);
}#python
def linq16():
customers = shared.getCustomerList()
the_date = datetime.datetime(1998, 1, 1)
order_greater_than_date = ((customer, order)
for customer in customers
for order in customer.Orders
if order.OrderDate > the_date)
orders = (SimpleNamespace(customer_id=x[0].CustomerID,
order_id=x[1].OrderID,
orderDate=x[1].OrderDate)
for x in order_greater_than_date)
shared.print_namespace(orders){CustomerId: ALFKI, OrderId: 10835, OrderDate: 1998-01-15 00:00:00.000}
{CustomerId: ALFKI, OrderId: 10952, OrderDate: 1998-03-16 00:00:00.000}
{CustomerId: ALFKI, OrderId: 11011, OrderDate: 1998-04-09 00:00:00.000}
{CustomerId: ANATR, OrderId: 10926, OrderDate: 1998-03-04 00:00:00.000}
{CustomerId: ANTON, OrderId: 10856, OrderDate: 1998-01-28 00:00:00.000}
...
This sample uses a nested projection to flatten the customer orders, then filters the orders where the order total is greater than 2000.00.
//c#
static void Linq17()
{
var customers = GetCustomerList();
var orders = customers
.SelectMany(customer => customer.Orders, (customer, order) => new { customer, order })
.Where(x => x.order.Total >= 2000.00M)
.Select(x =>
new
{
x.customer.CustomerID,
x.order.OrderID,
x.order.Total
});
ObjectDumper.Write(orders);
}#python
def linq17():
customers = shared.getCustomerList()
orders_greater_than_2000 = ((customer, order)
for customer in customers
for order in customer.Orders
if order.Total > 2000.00)
orders = (SimpleNamespace(customer_id=x[0].CustomerID,
order_id=x[1].OrderID,
total=x[1].Total)
for x in orders_greater_than_2000)
shared.print_namespace(orders)(customer_id='ANTON', order_id=10573, total=2082.0)
(customer_id='AROUT', order_id=10558, total=2142.9)
(customer_id='AROUT', order_id=10953, total=4441.25)
(customer_id='BERGS', order_id=10384, total=2222.4)
(customer_id='BERGS', order_id=10524, total=3192.65)
...
This sample fist filters on all Customers in Washington, then uses a nested projection to flatten the customer orders, then filtering on all orders greater than the cut-off date
//c#
static void Linq18()
{
var customers = GetCustomerList();
var orders = customers
.Where(c => c.Region == "WA")
.SelectMany(customer => customer.Orders, (customer, order) => new { customer, order })
.Where(x => x.order.OrderDate >= cutoffDate)
.Select(x =>
new
{
x.customer.CustomerID,
x.customer.Region,
x.order.OrderID
});
ObjectDumper.Write(orders);
}#python
def linq18():
customers = shared.getCustomerList()
the_date = datetime.datetime(1998, 1, 1)
order_greater_than_date = ((customer, order)
for customer in customers
for order in customer.Orders
if order.OrderDate > the_date)
orders = (SimpleNamespace(customer_id=x[0].CustomerID,
order_id=x[1].OrderID,
orderDate=x[1].OrderDate)
for x in order_greater_than_date)
shared.print_namespace(orders)(customer_id='ALFKI', orderDate=datetime.datetime(1998, 1, 15, 0, 0), order_id=10835)
(customer_id='ALFKI', orderDate=datetime.datetime(1998, 3, 16, 0, 0), order_id=10952)
(customer_id='ALFKI', orderDate=datetime.datetime(1998, 4, 9, 0, 0), order_id=11011)
(customer_id='ANATR', orderDate=datetime.datetime(1998, 3, 4, 0, 0), order_id=10926)
(customer_id='ANTON', orderDate=datetime.datetime(1998, 1, 28, 0, 0), order_id=10856)
...
//c#
public void Linq19()
{
var customers = GetCustomerList();
var customerOrders =
customers.SelectMany(
(cust, custIndex) =>
cust.Orders.Select(o => $"Customer #{custIndex + 1}) has an order with OrderID {o.OrderID}"));
ObjectDumper.Write(customerOrders);
}#python
def linq19():
customers = shared.getCustomerList()
index = 0
def get_cust_index_func():
nonlocal index
index += 1
return index
customer_orders = ((cust, get_cust_index_func(), order) for cust in customers for order in cust.Orders)
for triplet in customer_orders:
print("Customer #%d has an order with OrderID %d" % (triplet[1], triplet[2].OrderID))Customer #1 has an order with OrderID 10643
Customer #1 has an order with OrderID 10692
Customer #1 has an order with OrderID 10702
Customer #1 has an order with OrderID 10835
Customer #1 has an order with OrderID 10952
Customer #1 has an order with OrderID 11011
Customer #2 has an order with OrderID 10308
Customer #2 has an order with OrderID 10625
Customer #2 has an order with OrderID 10759
Customer #2 has an order with OrderID 10926
...
This sample uses a partition/slice to get only the first 3 elements of the array.
//c#
static void Linq20()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var first3Numbers = numbers.Take(3);
Console.WriteLine("First 3 numbers:");
first3Numbers.ForEach(Console.WriteLine);
}#python
def linq20():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
first3_numbers = numbers[:3]
print("First 3 numbers:")
shared.printN(first3_numbers)First 3 numbers:
5
4
1
This sample uses a partition/slice to get the first 3 orders from customers in Washington.
//c#
static void Linq21()
{
var customers = GetCustomerList();
var first3WAOrders = customers
.Where(c => c.Region == "WA")
.SelectMany(customer => customer.Orders, (customer, order) => new { customer, order })
.Select(x =>
new
{
x.customer.CustomerID,
x.order.OrderID,
x.order.OrderDate
})
.Take(3);
Console.WriteLine("First 3 orders in WA:");
first3WAOrders.ForEach(ObjectDumper.Write);
}#python
def linq21():
customers = shared.getCustomerList()
order_greater_than_date = ((cust, order)
for cust in customers
for order in cust.Orders
if cust.Region == "WA")
orders = [SimpleNamespace(customer_id=x[0].CustomerID,
order_id=x[1].OrderID,
orderDate=x[1].OrderDate)
for x in order_greater_than_date]
first_3_orders = orders[:3]
print("First 3 orders in WA:")
shared.print_namespace(first_3_orders)First 3 orders in WA:
(customer_id='LAZYK', orderDate=datetime.datetime(1997, 3, 21, 0, 0), order_id=10482)
(customer_id='LAZYK', orderDate=datetime.datetime(1997, 5, 22, 0, 0), order_id=10545)
(customer_id='TRAIH', orderDate=datetime.datetime(1997, 6, 19, 0, 0), order_id=10574)
This sample uses a partition to get all but the first four elements of the array.
//c#
static void Linq22()
{
var numbers = new []{ 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var allButFirst4Numbers = numbers.Skip(4);
Console.WriteLine("All but first 4 numbers:");
allButFirst4Numbers.ForEach(Console.WriteLine);
}#python
def linq22():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
all_but_first4_numbers = numbers[4:]
print("All but first 4 numbers:")
shared.printN(all_but_first4_numbers)All but first 4 numbers:
9
8
6
7
2
0
This sample uses Take to get all but the first 2 orders from customers in Washington.
//c#
static void Linq23()
{
var customers = GetCustomerList();
var waOrders = customers
.Where(c => c.Region == "WA")
.SelectMany(customer => customer.Orders, (customer, order) => new { customer, order })
.Select(x =>
new
{
x.customer.CustomerID,
x.order.OrderID,
x.order.OrderDate
});
var allButFirst2Orders = waOrders.Skip(2);
Console.WriteLine("All but first 2 orders in WA:");
ObjectDumper.Write(allButFirst2Orders);
}#python
def linq23():
customers = shared.getCustomerList()
wa_customers = filter(lambda c: c.Region == "WA", customers)
wa_customer_orders = functions.select_many(wa_customers, "Orders")
customer_orders = map(lambda x: SimpleNamespace(customer_id=x.item_a.CustomerID,
order_id=x.item_b.OrderID,
order_date=x.item_b.OrderDate),
wa_customer_orders)
all_but_first2 = list(customer_orders)[2:]
print("All but first 2 orders in WA:")
shared.print_namespace(all_but_first2)All but first 2 orders in WA:
(customer_id='TRAIH', orderDate=datetime.datetime(1997, 6, 19, 0, 0), order_id=10574)
(customer_id='TRAIH', orderDate=datetime.datetime(1997, 6, 23, 0, 0), order_id=10577)
(customer_id='TRAIH', orderDate=datetime.datetime(1998, 1, 8, 0, 0), order_id=10822)
(customer_id='WHITC', orderDate=datetime.datetime(1996, 7, 31, 0, 0), order_id=10269)
(customer_id='WHITC', orderDate=datetime.datetime(1996, 11, 1, 0, 0), order_id=10344)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 3, 10, 0, 0), order_id=10469)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 3, 24, 0, 0), order_id=10483)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 4, 11, 0, 0), order_id=10504)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 7, 11, 0, 0), order_id=10596)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 10, 6, 0, 0), order_id=10693)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 10, 8, 0, 0), order_id=10696)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 10, 30, 0, 0), order_id=10723)
(customer_id='WHITC', orderDate=datetime.datetime(1997, 11, 13, 0, 0), order_id=10740)
(customer_id='WHITC', orderDate=datetime.datetime(1998, 1, 30, 0, 0), order_id=10861)
(customer_id='WHITC', orderDate=datetime.datetime(1998, 2, 24, 0, 0), order_id=10904)
(customer_id='WHITC', orderDate=datetime.datetime(1998, 4, 17, 0, 0), order_id=11032)
(customer_id='WHITC', orderDate=datetime.datetime(1998, 5, 1, 0, 0), order_id=11066)
This sample uses a partition to return elements starting from the beginning of the array until a number is read whose value is not less than 6.
//c#
static void Linq24()
{
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var firstNumbersLessThan6 = numbers.TakeWhile(n => n < 6);
Console.WriteLine("First numbers less than 6:");
firstNumbersLessThan6.ForEach(Console.WriteLine);
}#python
def linq24():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
first_numbers_less_than6 = takewhile(lambda x: x < 6, numbers)
print("First numbers less than 6:")
shared.printN(first_numbers_less_than6)First numbers less than 6:
5
4
1
3
This sample uses a partition to return elements starting from the beginning of the array until a number is hit that is less than its position in the array.
//c#
static void Linq25()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var firstSmallNumbers = numbers.TakeWhile((n, index) => n >= index);
Console.WriteLine("First numbers not less than their position:");
firstSmallNumbers.ForEach(Console.WriteLine);
}#python
def linq25():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
index = 0
def digit_greater_equal_to_index(digit):
nonlocal index
result = digit >= index
index += 1
return result
first_small_numbers = takewhile(digit_greater_equal_to_index, numbers)
print("First numbers not less than their position:")
shared.printN(first_small_numbers)First numbers not less than their position:
5
4
This sample uses a partition to get the elements of the array starting from the first element divisible by 3.
//c#
static void Linq26()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var allButFirst3Numbers = numbers.SkipWhile(n => n % 3 != 0);
Console.WriteLine("All elements starting from first element divisible by 3:");
allButFirst3Numbers.ForEach(Console.WriteLine);
}#python
def linq26():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
all_but_first3_numbers = dropwhile(lambda n: n % 3 != 0, numbers)
print("All elements starting from first element divisible by 3:")
shared.printN(all_but_first3_numbers)All elements starting from first element divisible by 3:
3
9
8
6
7
2
0
This sample uses a partition to get the elements of the array starting from the first element less than its position.
//c#
static void Linq27()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var laterNumbers = numbers.SkipWhile((n, index) => n >= index);
Console.WriteLine("All elements starting from first element less than its position:");
laterNumbers.ForEach(Console.WriteLine);
}#python
def linq27():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
index = 0
def digit_greater_equal_to_index(digit):
nonlocal index
result = digit >= index
index += 1
return result
later_numbers = dropwhile(digit_greater_equal_to_index, numbers)
print("All elements starting from first element less than its position:")
shared.printN(later_numbers)All elements starting from first element less than its position:
1
3
9
8
6
7
2
0
This sample uses ordering to sort a list of words alphabetically.
//c#
static void Linq28()
{
var words = new [] { "cherry", "apple", "blueberry" };
var sortedWords = words.OrderBy(w => w);
Console.WriteLine("The sorted list of words:");
sortedWords.ForEach(Console.WriteLine);
}#python
def linq28():
words = ["cherry", "apple", "blueberry"]
sorted_words = sorted(words)
print("The sorted list of words:")
shared.printS(sorted_words)The sorted list of words:
apple
blueberry
cherry
This sample uses ordering to sort a list of words by length.
//c#
static void Linq29()
{
var words = new [] { "cherry", "apple", "blueberry" };
var sortedWords = words.OrderBy(w => w.Length);
Console.WriteLine("The sorted list of words (by length):");
sortedWords.ForEach(Console.WriteLine);
}#python
def linq29():
words = ["cherry", "apple", "blueberry"]
sorted_words = sorted(words, key=lambda x: len(x))
print("The sorted list of words (by length):")
shared.printS(sorted_words)The sorted list of words (by length):
apple
cherry
blueberry
This sample uses ordering to sort a list of products by name.
//c#
static void Linq30()
{
var products = GetProductList();
var sortedProducts = products.OrderBy(p => p.ProductName);
ObjectDumper.Write(sortedProducts);
}#python
def linq30():
products = shared.getProductList()
sorted_products = sorted(products, key=lambda p: p.ProductName)
shared.print_namespace(sorted_products){productId: 17, productName: Alice Mutton, category: Meat/Poultry, unitPrice: 39.0, unitsInStock: 0}
{productId: 3, productName: Aniseed Syrup, category: Condiments, unitPrice: 10.0, unitsInStock: 13}
{productId: 40, productName: Boston Crab Meat, category: Seafood, unitPrice: 18.4, unitsInStock: 123}
{productId: 60, productName: Camembert Pierrot, category: Dairy Products, unitPrice: 34.0, unitsInStock: 19}
{productId: 18, productName: Carnarvon Tigers, category: Seafood, unitPrice: 62.5, unitsInStock: 42}
...
This sample uses case-insensitive ordering to sort the words in an array.
//c#
static void Linq31()
{
var words = new [] { "aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry" };
var sortedWords = words.OrderBy(a => a, StringComparer.CurrentCultureIgnoreCase);
ObjectDumper.Write(sortedWords);
}#python
def linq31():
words = ["aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry"]
sorted_words = sorted(words, key=lambda s: s.casefold())
shared.printS(sorted_words)AbAcUs
aPPLE
BlUeBeRrY
bRaNcH
cHeRry
ClOvEr
This sample uses reverse ordering to sort a list of doubles from highest to lowest.
//c#
static void Linq32()
{
var doubles = new[]{ 1.7, 2.3, 1.9, 4.1, 2.9 };
var sortedDoubles = doubles.OrderByDescending(d => d);
Console.WriteLine("The doubles from highest to lowest:");
sortedDoubles.ForEach(Console.WriteLine);
}#python
def linq32():
doubles = [1.7, 2.3, 1.9, 4.1, 2.9]
sorted_doubles = sorted(doubles, reverse=True)
print("The doubles from highest to lowest:")
shared.printN(sorted_doubles)The doubles from highest to lowest:
4.1
2.9
2.3
1.9
1.7
This sample uses reverse ordering to sort a list of products by units in stock from highest to lowest.
//c#
static void Linq33()
{
var products = GetProductList();
var sortedProducts = products.OrderByDescending(p => p.UnitsInStock);
ObjectDumper.Write(sortedProducts);
}#python
def linq33():
products = shared.getProductList()
sorted_products = sorted(products, key=lambda p: p.UnitsInStock, reverse=True)
shared.print_namespace(sorted_products){productId: 75, productName: Rh�nbr�u Klosterbier, category: Beverages, unitPrice: 7.75, unitsInStock: 125}
{productId: 40, productName: Boston Crab Meat, category: Seafood, unitPrice: 18.4, unitsInStock: 123}
{productId: 6, productName: Grandma's Boysenberry Spread, category: Condiments, unitPrice: 25.0, unitsInStock: 120}
{productId: 55, productName: P�t� chinois, category: Meat/Poultry, unitPrice: 24.0, unitsInStock: 115}
{productId: 61, productName: Sirop d'�rable, category: Condiments, unitPrice: 28.5, unitsInStock: 113}
...
This sample uses reverse case-insensitive ordering to sort the words in an array.
//c#
static void Linq34()
{
var words = new [] { "aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry" };
var sortedWords = words.OrderByDescending(a => a, StringComparer.CurrentCultureIgnoreCase);
ObjectDumper.Write(sortedWords);
}#python
def linq34():
words = ["aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry"]
sorted_words = sorted(words, key=lambda s: s.casefold(), reverse=True)
shared.print_namespace(sorted_words)ClOvEr
cHeRry
bRaNcH
BlUeBeRrY
aPPLE
AbAcUs
This sample uses nested ordering, first by length of their name, and then alphabetically by the name itself.
//c#
static void Linq35()
{
var digits = new [] { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var sortedDigits = digits
.OrderBy(d => d.Length)
.ThenBy(d => d);
Console.WriteLine("Sorted digits:");
sortedDigits.ForEach(Console.WriteLine);
}#python
def linq35():
digits = ["zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]
sorted_digits = sorted(digits, key=lambda digit: (len(digit), digit))
print("Sorted digits:")
shared.printS(sorted_digits)Sorted digits:
one
six
two
five
four
nine
zero
eight
seven
three
This sample uses case-insensitive nested ordering, with a custom comparer to sort first by word length and then by a case-insensitive sort of the words in an array.
//c#
static void Linq36()
{
var words = new [] { "aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry" };
var sortedWords = words
.OrderBy(a => a.Length)
.ThenBy(a => a, StringComparer.CurrentCultureIgnoreCase);
ObjectDumper.Write(sortedWords);
}#python
def linq36():
words = ["aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry"]
sorted_words = sorted(words, key=lambda word: (len(word), word.casefold()))
shared.printS(sorted_words)aPPLE
AbAcUs
bRaNcH
cHeRry
ClOvEr
BlUeBeRrY
This sample uses nested ordering to sort a list of products, first by category, and then by unit price, from highest to lowest.
//c#
public void Linq37()
{
List<Product> products = GetProductList();
var sortedProducts = products
.OrderBy(p => p.Category)
.ThenByDescending(p => p.UnitPrice);
ObjectDumper.Write(sortedProducts);
}#python
def linq37():
products = shared.getProductList()
# negate secondary sort because its a number for reverse order
sorted_products = sorted(products, key=lambda product: (product.Category, -product.UnitPrice))
shared.print_namespace(sorted_products){productId: 38, productName: C�te de Blaye, category: Beverages, unitPrice: 263.5, unitsInStock: 17}
{productId: 43, productName: Ipoh Coffee, category: Beverages, unitPrice: 46.0, unitsInStock: 17}
{productId: 2, productName: Chang, category: Beverages, unitPrice: 19.0, unitsInStock: 17}
{productId: 76, productName: Lakkalik��ri, category: Beverages, unitPrice: 18.0, unitsInStock: 57}
{productId: 39, productName: Chartreuse verte, category: Beverages, unitPrice: 18.0, unitsInStock: 69}
{productId: 1, productName: Chai, category: Beverages, unitPrice: 18.0, unitsInStock: 39}
{productId: 35, productName: Steeleye Stout, category: Beverages, unitPrice: 18.0, unitsInStock: 20}
{productId: 70, productName: Outback Lager, category: Beverages, unitPrice: 15.0, unitsInStock: 15}
{productId: 34, productName: Sasquatch Ale, category: Beverages, unitPrice: 14.0, unitsInStock: 111}
...
This sample uses uses case-insensitive reverse nested ordering to sort first by word length and then by a case-insensitive descending sort of the words in an array.
//c#
static void Linq38()
{
var words = new [] { "aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry" };
var sortedWords = words
.OrderBy(a => a.Length)
.ThenByDescending(a => a, StringComparer.CurrentCultureIgnoreCase);
ObjectDumper.Write(sortedWords);
}#python
def linq38():
words = ["aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry"]
# two pass sort, sort by least significant first
sorted_words = sorted(words, key=lambda word: word.casefold(), reverse=True)
sorted_words = sorted(sorted_words, key=lambda word: len(word))
shared.printS(sorted_words)aPPLE
ClOvEr
cHeRry
bRaNcH
AbAcUs
BlUeBeRrY
This sample uses reverse ordering to create a list of all digits in the array whose second letter is 'i' that is reversed from the order in the original array.
//c#
static void Linq39()
{
var digits = new [] { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var reversedIDigits = digits
.Where(d => d[1] == 'i')
.Reverse();
Console.WriteLine("A backwards list of the digits with a second character of 'i':");
reversedIDigits.ForEach(Console.WriteLine);
}#python
def linq39():
digits = ["zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]
reversed_i_digits = reversed(list(filter(lambda digit: digit[1] == "i", digits)))
print("A backwards list of the digits with a second character of 'i':")
shared.printS(reversed_i_digits)A backwards list of the digits with a second character of 'i':
nine
eight
six
five
This sample uses grouping to partition a list of numbers by their remainder when divided by 5.
//c#
static void Linq40()
{
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var numberGroups = numbers
.GroupBy(n => n % 5)
.Select(x =>
new
{
Remainder = x.Key,
Numbers = x
});
numberGroups.ForEach((g) =>
{
Console.WriteLine("Numbers with a remainder of {0} when divided by 5:", g.Remainder);
g.Numbers.ForEach(Console.WriteLine);
});
}#python
def linq40():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
# First create a record of numbers and their modulus of 5
number_remainders = map(lambda n: SimpleNamespace(Number=n,
Remainder=n % 5),
numbers)
# Group By only works on sorted lists, so sort by both fields
sorted_by_reminder = sorted(number_remainders, key=lambda x: (x.Remainder, x.Number))
remainder_groups = groupby(sorted_by_reminder, key=lambda nr: nr.Remainder)
for key, items in remainder_groups:
print("Numbers with a remainder of %d when divided by 5:" % key)
for item in items:
print(item.Number)Numbers with a remainder of 0 when divided by 5:
5
0
Numbers with a remainder of 1 when divided by 5:
1
6
Numbers with a remainder of 2 when divided by 5:
7
2
Numbers with a remainder of 3 when divided by 5:
3
8
Numbers with a remainder of 4 when divided by 5:
4
9
This sample uses grouping to partition a list of words by their first letter.
//c#
static void Linq41()
{
var words = new [] { "blueberry", "chimpanzee", "abacus", "banana", "apple", "cheese" };
var wordGroups = words
.GroupBy(w => w[0])
.Select(g =>
new
{
FirstLetter = g.Key,
Words = g
});
wordGroups.ForEach((g) =>
{
Console.WriteLine($"Words that start with the letter '{g.FirstLetter}':");
g.Words.ForEach(Console.WriteLine);
});
}#python
def linq41():
words = ["blueberry", "chimpanzee", "abacus", "banana", "apple", "cheese"]
first_letter_words = map(lambda w: SimpleNamespace(Letter=w[0],
Word=w),
words)
# Group By only works on sorted lists, so sort by both fields
sorted_letter_words = sorted(first_letter_words, key=lambda x: (x.Word, x.Letter))
letter_groups = groupby(sorted_letter_words, key=lambda nr: nr.Letter)
for key, items in letter_groups:
print("Words that start with the letter '%s':" % key)
for item in items:
print(item.Word)Words that start with the letter 'a':
abacus
apple
Words that start with the letter 'b':
banana
blueberry
Words that start with the letter 'c':
cheese
chimpanzee
This sample uses grouping to partition a list of products by category.
//c#
static void Linq42()
{
var products = GetProductList();
var orderGroups = products
.GroupBy(p => p.Category)
.Select(g =>
new
{
Category = g.Key,
Products = g
});
ObjectDumper.Write(orderGroups, 1);
}#python
def linq42():
products = shared.getProductList()
sorted_by_category = sorted(products, key=lambda p: p.Category)
order_groups = groupby(sorted_by_category, key=lambda p: p.Category)
for key, items in order_groups:
print("Products in the category '%s':" % key)
print(list(items))Products in the category 'Beverages':
[{productId: 1, productName: Chai, category: Beverages, unitPrice: 18.00, unitsInStock: 39}, {productId: 2, productName: Products in the category 'Condiments':
[{productId: 3, productName: Aniseed Syrup, category: Condiments, unitPrice: 10.00, unitsInStock: 13}, {productId: 4, Products in the category 'Confections':
[{productId: 16, productName: Pavlova, category: Confections, unitPrice: 17.45, unitsInStock: 29}, {productId: 19, Products in the category 'Dairy Products':
[{productId: 11, productName: Queso Cabrales, category: Dairy Products, unitPrice: 21.00, unitsInStock: 22}, {productId: Products in the category 'Grains/Cereals':
[{productId: 22, productName: Gustaf's Knäckebröd, category: Grains/Cereals, unitPrice: 21.00, unitsInStock: 104}, Products in the category 'Meat/Poultry':
[{productId: 9, productName: Mishi Kobe Niku, category: Meat/Poultry, unitPrice: 97.00, unitsInStock: 29}, {productId: 17,Products in the category 'Produce':
[{productId: 7, productName: Uncle Bob's Organic Dried Pears, category: Produce, unitPrice: 30.00, unitsInStock: 15}, Products in the category 'Seafood':
[{productId: 10, productName: Ikura, category: Seafood, unitPrice: 31.00, unitsInStock: 31}, {productId: 13, productName:
This sample uses nested grouping to partition a list of each customer's orders, first by year, and then by month.
//c#
public void Linq43()
{
var customers = GetCustomerList();
var customerOrderGroups = customers
.Select(c => new
{
c.CompanyName,
YearGroups =
(
c.Orders
.GroupBy(y => y.OrderDate.Year)
.Select(YearGroup => new
{
Year = YearGroup.Key,
MonthGroups =
(
YearGroup
.GroupBy(m => m.OrderDate.Month)
.Select(MonthGroup => new
{
Month = MonthGroup.Key, Orders = MonthGroup
})
)
})
)
});
ObjectDumper.Write(customerOrderGroups, 3);
} #python
def linq43():
pass{CompanyName: Alfreds Futterkiste, YearGroups: {{Year: 1997, MonthGroups: {{Month: 8, Orders: {{orderId: 10643, orderDate: 1997-08-25 00:00:00.000, total: 814.5}}}, {Month: 10, Orders: {{orderId: 10692, orderDate: 1997-10-03 00:00:00.000, total: 878.0}, {orderId: 10702, orderDate: 1997-10-13 00:00:00.000, total: 330.0}}}}}, {Year: 1998, MonthGroups: {{Month: 1, Orders: {{orderId: 10835, orderDate: 1998-01-15 00:00:00.000, total: 845.8}}}, {Month: 3, Orders: {{orderId: 10952, orderDate: 1998-03-16 00:00:00.000, total: 471.2}}}, {Month: 4, Orders: {{orderId: 11011, orderDate: 1998-04-09 00:00:00.000, total: 933.5}}}}}}}
{CompanyName: Ana Trujillo Emparedados y helados, YearGroups: {{Year: 1996, MonthGroups: {{Month: 9, Orders: {{orderId: 10308, orderDate: 1996-09-18 00:00:00.000, total: 88.8}}}}}, {Year: 1997, MonthGroups: {{Month: 8, Orders: {{orderId: 10625, orderDate: 1997-08-08 00:00:00.000, total: 479.75}}}, {Month: 11, Orders: {{orderId: 10759, orderDate: 1997-11-28 00:00:00.000, total: 320.0}}}}}, {Year: 1998, MonthGroups: {{Month: 3, Orders: {{orderId: 10926, orderDate: 1998-03-04 00:00:00.000, total: 514.4}}}}}}}
This sample removes all duplicate elements in a sequence of factors of 300.
//c#
static void Linq46()
{
int[] factorsOf300 = { 2, 2, 3, 5, 5 };
var uniqueFactors = factorsOf300.Distinct();
Console.WriteLine("Prime factors of 300:");
uniqueFactors.ForEach(Console.WriteLine);
}#python
def linq46():
factors_of300 = [2, 2, 3, 5, 5]
unique_factors = set(factors_of300)
print("Prime factors of 300:")
shared.printN(unique_factors)Prime factors of 300:
2
3
5
This sample gets distint Category names from all the products.
//c#
static void Linq47()
{
var products = GetProductList();
var categoryNames = products
.Select(p => p.Category)
.Distinct();
Console.WriteLine("Category names:");
categoryNames.ForEach(Console.WriteLine);
}#python
def linq47():
products = shared.getProductList()
category_names = {p.Category for p in products}
print("Category names:")
shared.printS(category_names)Category names:
Beverages
Dairy Products
Condiments
Meat/Poultry
Produce
Seafood
Grains/Cereals
Confections
This sample creates a Union of sequences that contains unique values from both arrays.
//c#
static void Linq48()
{
int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };
int[] numbersB = { 1, 3, 5, 7, 8 };
var uniqueNumbers = numbersA.Union(numbersB);
Console.WriteLine("Unique numbers from both arrays:");
uniqueNumbers.ForEach(Console.WriteLine);
} #python
def linq48():
numbers_a = [0, 2, 4, 5, 6, 8, 9]
numbers_b = [1, 3, 5, 7, 8]
unique_numbers = set(numbers_a + numbers_b)
print("Unique numbers from both arrays:")
shared.printN(unique_numbers)Unique numbers from both arrays:
0
1
2
3
4
5
6
7
8
9
This sample creates a Union of sequences that contains the distinct first letter from both product and customer names
//c#
static void Linq49()
{
var products = GetProductList();
var customers = GetCustomerList();
var productFirstChars = products.Select(p => p.ProductName[0]);
var customerFirstChars = customers.Select(c => c.CompanyName[0]);
var uniqueFirstChars = productFirstChars.Union(customerFirstChars);
Console.WriteLine("Unique first letters from Product names and Customer names:");
uniqueFirstChars.ForEach(Console.WriteLine);
}#python
def linq49():
products = shared.getProductList()
customers = shared.getCustomerList()
product_first_chars = {p.ProductName[0] for p in products}
customer_first_chars = {c.CompanyName[0] for c in customers}
unique_first_chars = product_first_chars.union(customer_first_chars)
print("Unique first letters from Product names and Customer names:")
shared.printS(unique_first_chars)Unique first letters from Product names and Customer names:
G
W
R
I
P
Z
L
U
C
O
N
F
A
D
T
E
J
K
S
Q
H
M
B
V
This sample creates Intersection that contains the common values shared by both arrays.
//c#
static void Linq50()
{
int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };
int[] numbersB = { 1, 3, 5, 7, 8 };
var commonNumbers = numbersA.Intersect(numbersB);
Console.WriteLine("Common numbers shared by both arrays:");
commonNumbers.ForEach(Console.WriteLine);
}#python
def linq50():
numbers_a = [0, 2, 4, 5, 6, 8, 9]
numbers_b = [1, 3, 5, 7, 8]
common_numbers = set(numbers_a).intersection((set(numbers_b)))
print("Common numbers shared by both arrays:")
shared.printN(common_numbers)Common numbers shared by both arrays:
8
5
This sample creates Intersection that contains contains the common first letter from both product and customer names.
//c#
static void Linq51()
{
var products = GetProductList();
var customers = GetCustomerList();
var productFirstChars = products.Select(p => p.ProductName[0]);
var customerFirstChars = customers.Select(c => c.CompanyName[0]);
var commonFirstChars = productFirstChars.Intersect(customerFirstChars);
Console.WriteLine("Common first letters from Product names and Customer names:");
commonFirstChars.ForEach(Console.WriteLine);
} #python
def linq51():
products = shared.getProductList()
customers = shared.getCustomerList()
product_first_chars = {p.ProductName[0] for p in products}
customer_first_chars = {c.CompanyName[0] for c in customers}
unique_first_chars = product_first_chars.intersection(customer_first_chars)
print("Common first letters from Product names and Customer names:")
shared.printS(unique_first_chars)Common first letters from Product names and Customer names:
A
T
C
E
Q
O
W
P
F
S
G
L
V
M
K
N
I
B
R
This sample creates a sequence that excludes the values from the second sequence.
//c#
static void Linq52()
{
int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };
int[] numbersB = { 1, 3, 5, 7, 8 };
var aOnlyNumbers = numbersA.Except(numbersB);
Console.WriteLine("Numbers in first array but not second array:");
aOnlyNumbers.ForEach(Console.WriteLine);
}#python
def linq52():
numbers_a = [0, 2, 4, 5, 6, 8, 9]
numbers_b = [1, 3, 5, 7, 8]
a_only_numbers = set(numbers_a).difference((set(numbers_b)))
print("Numbers in first array but not second array:")
shared.printN(a_only_numbers)Numbers in first array but not second array:
0
9
2
4
6
This sample creates a sequence that the first letters of product names that but excludes letters of customer names first letter.
//c#
static void Linq53()
{
var products = GetProductList();
var customers = GetCustomerList();
var productFirstChars = products.Select(p => p.ProductName[0]);
var customerFirstChars = customers.Select(c => c.CompanyName[0]);
var productOnlyFirstChars = productFirstChars.Except(customerFirstChars);
Console.WriteLine("First letters from Product names, but not from Customer names:");
productOnlyFirstChars.ForEach(Console.WriteLine);
} #python
def linq53():
products = shared.getProductList()
customers = shared.getCustomerList()
product_first_chars = {p.ProductName[0] for p in products}
customer_first_chars = {c.CompanyName[0] for c in customers}
unique_first_chars = product_first_chars.difference(customer_first_chars)
print("First letters from Product names, but not from Customer names:")
shared.printS(unique_first_chars)First letters from Product names, but not from Customer names:
Z
J
U
This sample converts a list ti an array.
//c#
static void Linq54()
{
var list = new List<double> { 1.7, 2.3, 1.9, 4.1, 2.9 };
var doublesArray = list
.OrderByDescending(d => d)
.ToArray();
Console.WriteLine("Every other double from highest to lowest:");
for (var d = 0; d < doublesArray.Length; d += 2)
{
Console.WriteLine(doublesArray[d]);
}
}#python
def linq54():
doubles = [1.7, 2.3, 1.9, 4.1, 2.9]
sorted_doubles = sorted(doubles, reverse=True)
doubles_array = list(sorted_doubles)
print("Every other double from highest to lowest:")
d = 0
while d < len(doubles_array):
print(doubles_array[d])
d += 2Every other double from highest to lowest:
4.1
2.3
1.7
This sample converts an array to a list
//c#
static void Linq55()
{
var words = new[] { "cherry", "apple", "blueberry" };
var wordList = words
.OrderBy(x => x)
.ToList();
Console.WriteLine("The sorted word list:");
wordList.ForEach(Console.WriteLine);
}#python
def linq55():
words = ["cherry", "apple", "blueberry"]
sorted_words = sorted(words)
word_list = list(sorted_words)
print("The sorted word list:")
shared.printN(word_list)The sorted word list:
apple
blueberry
cherry
This sample converts an array of records to a dictionary
//c#
static void Linq56()
{
var scoreRecords =
new[]
{
new {Name = "Alice", Score = 50},
new {Name = "Bob" , Score = 40},
new {Name = "Cathy", Score = 45}
};
var scoreRecordsDict = scoreRecords.ToDictionary(sr => sr.Name);
Console.WriteLine("Bob's score: {0}", scoreRecordsDict["Bob"]);
}#python
def linq56():
score_records = [{'Name': "Alice", 'Score': 50},
{'Name': "Bob", 'Score': 40},
{'Name': "Cathy", 'Score': 45}]
score_records_dict = {s['Name']:s['Score'] for s in score_records}
print("Bob's score: %s" % score_records_dict["Bob"])Bob's score: {Name: Bob, Score: 40}
This sample filters all elements that matches the type double/float.
//c#
static void Linq57()
{
var numbers = new object[]{ null, 1.0, "two", 3, "four", 5, "six", 7.0 };
var doubles = numbers.OfType<double>();
Console.WriteLine("Numbers stored as doubles:");
doubles.ForEach(Console.WriteLine);
} #python
def linq57():
numbers = [None, 1.0, "two", 3, "four", 5, "six", 7.0]
floats = (n for n in numbers if isinstance(n, float))
print("Numbers stored as floats:")
shared.printN(floats)Numbers stored as doubles:
1.0
7.0
This sample returns the first matching element as a Product, instead of as a sequence containing a Product.
//c#
static void Linq58()
{
var products = GetProductList();
var product12 = products.First(p => p.ProductID == 12);
ObjectDumper.Write(product12);
}#python
def linq58():
products = shared.getProductList()
product_12 = next(filter(lambda p: p.ProductID == 12, products))
print(product_12){productId: 12, productName: Queso Manchego La Pastora, category: Dairy Products, unitPrice: 38.0, unitsInStock: 86}
This sample finds the first element in the array that starts with 'o'.
//c#
static void Linq59()
{
var strings = new []{ "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var startsWithO = strings.First(s => s.StartsWith('o'));
Console.WriteLine("A string starting with 'o': {0}", startsWithO);
}#python
def linq59():
strings = ["zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]
starts_with_o = next(s for s in strings if s[0] == 'o')
print("A string starting with 'o': %s" % starts_with_o)A string starting with 'o': one
This sample returns the first or default if nothing is found, to try to return the first element of the sequence unless there are no elements, in which case the default value for that type is returned.
//c#
static void Linq61()
{
var numbers = new int[0];
var firstNumOrDefault = numbers.FirstOrDefault();
Console.WriteLine(firstNumOrDefault);
}#python
def linq61():
numbers = []
first_num_or_default = next((n for n in numbers), 0)
print(first_num_or_default)0
This sample returns the first or default if nothing is found, to return the first product whose ProductID is 789 as a single Product object, unless there is no match, in which case null is returned.
//c#
static void Linq62()
{
var products = GetProductList();
var product789 = products.FirstOrDefault(p => p.ProductID == 789);
Console.WriteLine("Product 789 exists: {0}", product789 != null);
}#python
def linq62():
products = shared.getProductList()
product789 = next((p for p in products if p.ProductID == 789), None)
print("Product 789 exists: %s" % (product789 is not None))Product 789 exists: False
This sample retrieve the second number greater than 5 from an array.
//c#
static void Linq64()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var fourthLowNum = numbers
.Where(num => num > 5)
.ElementAt(1);
Console.WriteLine("Second number > 5: {0}", fourthLowNum);
} #python
def linq64():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
second_number_greater_than_5 = [n for n in numbers if n > 5][1]
print("Second number > 5: %d" % second_number_greater_than_5)Second number > 5: 8
This sample uses generates a sequence of numbers from 100 to 149 that is used to find which numbers in that range are odd and even.
//c#
static void Linq65()
{
var numbers = Enumerable.Range(100, 50)
.Select(n =>
new
{
Number = n,
OddEven = n % 2 == 1 ? "odd" : "even"
});
numbers.ForEach((n) => Console.WriteLine("The number {0} is {1}.", n.Number, n.OddEven));
}#python
def linq65():
numbers = range(100, 150)
odd_even = ({'Number': n, 'OddEven': ("odd" if (n % 2 == 1) else "even")} for n in numbers)
for item in odd_even:
print("The number %s is %s" % (item['Number'], item['OddEven']))The number 100 is even.
The number 101 is odd.
The number 102 is even.
The number 103 is odd.
The number 104 is even.
The number 105 is odd.
The number 106 is even.
The number 107 is odd.
The number 108 is even.
The number 109 is odd.
The number 110 is even.
...
This sample uses generates a sequence of repeated numbers that contains the number 7 ten times.
//c#
static void Linq66()
{
var numbers = Enumerable.Repeat(7, 10);
numbers.ForEach(Console.WriteLine);
} #python
def linq66():
numbers = itertools.repeat(7, 10)
shared.printN(numbers)7
7
7
7
7
7
7
7
7
7
This sample uses determines if Any of the words in the array contain the substring 'ei'.
//c#
static void Linq67()
{
var words = new []{ "believe", "relief", "receipt", "field" };
var iAfterE = words.Any(w => w.Contains("ei"));
Console.WriteLine($"There is a word in the list that contains 'ei': {iAfterE}");
}#python
def linq67():
words = ["believe", "relief", "receipt", "field"]
i_after_e = any("ei" in w for w in words)
print("There is a word that contains in the list that contains 'ei': %s" % i_after_e)There is a word that contains in the list that contains 'ei': true
This sample determines if Any of the grouped a list of products only for categories that have at least one product that is out of stock.
//c#
static void Linq69()
{
var products = GetProductList();
var productGroups = products
.GroupBy(prod => prod.Category)
.Where(prodGroup => prodGroup.Any(p => p.UnitsInStock == 0))
.Select(prodGroup =>
new
{
Category = prodGroup.Key,
Products = prodGroup
});
ObjectDumper.Write(productGroups, 1);
}#python
def linq69():
pass{Category: Condiments, Products: {{productId: 3, productName: Aniseed Syrup, category: Condiments, unitPrice: 10.0, unitsInStock: 13}, {productId: 4, productName: Chef Anton's Cajun Seasoning, category: Condiments, unitPrice: 22.0, unitsInStock: 53}, {productId: 5, productName: Chef Anton's Gumbo Mix, category: Condiments, unitPrice: 21.35, unitsInStock: 0}, {productId: 6, productName: Grandma's Boysenberry Spread, category: Condiments, unitPrice: 25.0, unitsInStock: 120}, {productId: 8, productName: Northwoods Cranberry Sauce, category: Condiments, unitPrice: 40.0, unitsInStock: 6}, {productId: 15, productName: Genen Shouyu, category: Condiments, unitPrice: 15.5, unitsInStock: 39}, {productId: 44, productName: Gula Malacca, category: Condiments, unitPrice: 19.45, unitsInStock: 27}, {productId: 61, productName: Sirop d'�rable, category: Condiments, unitPrice: 28.5, unitsInStock: 113}, {productId: 63, productName: Vegie-spread, category: Condiments, unitPrice: 43.9, unitsInStock: 24}, {productId: 65, productName: Louisiana Fiery Hot Pepper Sauce, category: Condiments, unitPrice: 21.05, unitsInStock: 76}, {productId: 66, productName: Louisiana Hot Spiced Okra, category: Condiments, unitPrice: 17.0, unitsInStock: 4}, {productId: 77, productName: Original Frankfurter gr�ne So�e, category: Condiments, unitPrice: 13.0, unitsInStock: 32}}}
...
This sample determines if All the elements in the array contain only odd numbers.
//c#
static void Linq70()
{
var numbers = new [] { 1, 11, 3, 19, 41, 65, 19 };
var onlyOdd = numbers.All(n => n % 2 == 1);
Console.WriteLine($"The list contains only odd numbers: {onlyOdd}");
}#python
def linq70():
numbers = [1, 11, 3, 19, 41, 65, 19]
only_odd = all(n % 2 == 1 for n in numbers)
print("The list contains only odd numbers: %s" % only_odd)The list contains only odd numbers: true
This sample determines if All elements in the grouped a list of products by categories, have all of their products in stock.
//c#
static void Linq72()
{
var products = GetProductList();
var productGroups = products
.GroupBy(prod => prod.Category)
.Where(prodGroup => prodGroup.All(p => p.UnitsInStock > 0))
.Select(prodGroup =>
new
{
Category = prodGroup.Key,
Products = prodGroup
});
ObjectDumper.Write(productGroups, 1);
}#python
def linq72():
pass{Category: Grains/Cereals, Products: {{productId: 22, productName: Gustaf's Kn�ckebr�d, category: Grains/Cereals, unitPrice: 21.0, unitsInStock: 104}, {productId: 23, productName: Tunnbr�d, category: Grains/Cereals, unitPrice: 9.0, unitsInStock: 61}, {productId: 42, productName: Singaporean Hokkien Fried Mee, category: Grains/Cereals, unitPrice: 14.0, unitsInStock: 26}, {productId: 52, productName: Filo Mix, category: Grains/Cereals, unitPrice: 7.0, unitsInStock: 38}, {productId: 56, productName: Gnocchi di nonna Alice, category: Grains/Cereals, unitPrice: 38.0, unitsInStock: 21}, {productId: 57, productName: Ravioli Angelo, category: Grains/Cereals, unitPrice: 19.5, unitsInStock: 36}, {productId: 64, productName: Wimmers gute Semmelkn�del, category: Grains/Cereals, unitPrice: 33.25, unitsInStock: 22}}}
...
This sample gets the number of unique prime factors of 300.
//c#
static void Linq73()
{
var primeFactorsOf300 = new [] { 2, 2, 3, 5, 5 };
var uniqueFactors = primeFactorsOf300.Distinct().Count();
Console.WriteLine($"There are {uniqueFactors} unique prime factors of 300.");
}#python
def linq73():
factors_of_300 = [2, 2, 3, 5, 5]
unique_factors = len(set(factors_of_300))
print("There are %d unique factors of 300." % unique_factors)There are 3 unique factors of 300.
This sample gets the number of odd ints in the array.
//c#
static void Linq74()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var oddNumbers = numbers.Count(n => n % 2 == 1);
Console.WriteLine($"There are {oddNumbers} odd numbers in the list.");
}#python
def linq74():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
odd_numbers = sum(n % 2 == 1 for n in numbers)
print("There are %d odd numbers in the list." % odd_numbers)There are 5 odd numbers in the list.
This sample uses returns a list of customers and how many orders each has.
//c#
static void Linq76()
{
var customers = GetCustomerList();
var orderCounts = customers
.Select(cust =>
new
{
cust.CustomerID,
OrderCount = cust.Orders.Count()
});
ObjectDumper.Write(orderCounts);
}#python
def linq76():
customers = shared.getCustomerList()
order_counts = map(lambda cust: SimpleNamespace(CustomerID=cust.CustomerID,
OrderCount=len(cust.Orders)),
customers)
shared.print_namespace(order_counts){CustomerId: ALFKI, OrderCount: 6}
{CustomerId: ANATR, OrderCount: 4}
{CustomerId: ANTON, OrderCount: 7}
{CustomerId: AROUT, OrderCount: 13}
{CustomerId: BERGS, OrderCount: 18}
{CustomerId: BLAUS, OrderCount: 7}
{CustomerId: BLONP, OrderCount: 11}
...
This sample uses returns a list of categories and how many products each has.
//c#
static void Linq77()
{
var products = GetProductList();
var categoryCounts = products
.GroupBy(prod => prod.Category)
.Select(prodGroup =>
new
{
Category = prodGroup.Key,
ProductCount = prodGroup.Count()
});
ObjectDumper.Write(categoryCounts);
}#python
def linq77():
products = shared.getProductList()
sorted_by_category = sorted(products, key=lambda p: p.Category)
grouped_by_category = groupby(sorted_by_category, key=lambda p: p.Category)
category_counts = map(lambda g: SimpleNamespace(Category=g[0],
ProductCount=len(list(g[1]))),
grouped_by_category)
shared.print_namespace(category_counts){Category: Dairy Products, ProductCount: 10}
{Category: Grains/Cereals, ProductCount: 7}
{Category: Confections, ProductCount: 13}
{Category: Seafood, ProductCount: 12}
{Category: Condiments, ProductCount: 12}
{Category: Meat/Poultry, ProductCount: 6}
{Category: Produce, ProductCount: 5}
{Category: Beverages, ProductCount: 12}
This sample uses adds all the numbers in an array.
//c#
static void Linq78()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var numSum = numbers.Sum();
Console.WriteLine($"The sum of the numbers is {numSum}.");
}#python
def linq78():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
num_sum = sum(numbers)
print("The sum of the numbers is %d." % num_sum)The sum of the numbers is 45.
This sample gets the total number of characters of all words in the array.
//c#
static void Linq79()
{
var words = new [] { "cherry", "apple", "blueberry" };
var totalChars = words.Sum(w => w.Length);
Console.WriteLine($"There are a total of {totalChars} characters in these words.");
}#python
def linq79():
words = ["cherry", "apple", "blueberry"]
total_chars = sum(len(w) for w in words)
print("There are a total of %d characters in these words." % total_chars)There are a total of 20 characters in these words.
This sample gets the total units in stock for each product category.
//c#
static void Linq80()
{
var products = GetProductList();
var categories = products
.GroupBy(prod => prod.Category)
.Select(prodGroup =>
new
{
Category = prodGroup.Key,
TotalUnitsInStock = prodGroup.Sum(p => p.UnitsInStock)
});
ObjectDumper.Write(categories);
}#python
def linq80():
products = shared.getProductList()
sorted_by_category = sorted(products, key=lambda p: p.Category)
grouped_by_category = groupby(sorted_by_category, key=lambda p: p.Category)
category_counts = map(lambda g: SimpleNamespace(Category=g[0],
TotalUnitsInStock=sum(p.UnitsInStock for p in g[1])),
grouped_by_category)
shared.print_namespace(category_counts){Category: Dairy Products, TotalUnitsInStock: 393}
{Category: Grains/Cereals, TotalUnitsInStock: 308}
{Category: Confections, TotalUnitsInStock: 386}
{Category: Seafood, TotalUnitsInStock: 701}
{Category: Condiments, TotalUnitsInStock: 507}
{Category: Meat/Poultry, TotalUnitsInStock: 165}
{Category: Produce, TotalUnitsInStock: 100}
{Category: Beverages, TotalUnitsInStock: 559}
This sample uses gets the lowest number in an array.
//c#
static void Linq81()
{
var numbers = new []{ 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var minNum = numbers.Min();
Console.WriteLine($"The minimum number is {minNum}.");
} #python
def linq81():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
min_num = min(numbers)
print("The minimum number is %d" % min_num)The minimum number is 0.
This sample uses gets the length of the shortest word in an array.>
//c#
static void Linq82()
{
var words = new [] { "cherry", "apple", "blueberry" };
var shortestWord = words.Min(w => w.Length);
Console.WriteLine($"The shortest word is {shortestWord} characters long.");
}#python
def linq82():
words = ["cherry", "apple", "blueberry"]
shortest_word = min(len(w) for w in words)
print("The shortest word is %d characters long." % shortest_word)The shortest word is 5 characters long.
This sample uses gets the cheapest price among each category's products.
//c#
static void Linq83()
{
var products = GetProductList();
var categories = products
.GroupBy(prod => prod.Category)
.Select(prodGroup =>
new
{
Category = prodGroup.Key,
CheapestPrice = prodGroup.Min(p => p.UnitPrice)
});
ObjectDumper.Write(categories);
}#python
def linq83():
products = shared.getProductList()
sorted_by_category = sorted(products, key=lambda p: p.Category)
grouped_by_category = groupby(sorted_by_category, key=lambda p: p.Category)
category_cheapest_price = map(lambda g: SimpleNamespace(Category=g[0],
CheapestPrice=min(p.UnitPrice for p in g[1])),
grouped_by_category)
shared.print_namespace(category_cheapest_price){Category: Dairy Products, CheapestPrice: 2.5}
{Category: Grains/Cereals, CheapestPrice: 7.0}
{Category: Confections, CheapestPrice: 9.2}
{Category: Seafood, CheapestPrice: 6.0}
{Category: Condiments, CheapestPrice: 10.0}
{Category: Meat/Poultry, CheapestPrice: 7.45}
{Category: Produce, CheapestPrice: 10.0}
{Category: Beverages, CheapestPrice: 4.5}
This sample gets the products with the lowest price in each category.
//c#
static void Linq84()
{
var products = GetProductList();
var categories = products.GroupBy(prod => prod.Category)
.Select(prodGroup => new {prodGroup, minPrice = prodGroup.Min(p => p.UnitPrice)})
.Select(x =>
new
{
Category = x.prodGroup.Key,
CheapestProducts = x.prodGroup.Where(p => p.UnitPrice == x.minPrice)
});
ObjectDumper.Write(categories, 1);
}#python
def linq84():
pass{Category: Dairy Products, CheapestProducts: {{productId: 33, productName: Geitost, category: Dairy Products, unitPrice: 2.5, unitsInStock: 112}}}
{Category: Grains/Cereals, CheapestProducts: {{productId: 52, productName: Filo Mix, category: Grains/Cereals, unitPrice: 7.0, unitsInStock: 38}}}
{Category: Confections, CheapestProducts: {{productId: 19, productName: Teatime Chocolate Biscuits, category: Confections, unitPrice: 9.2, unitsInStock: 25}}}
{Category: Seafood, CheapestProducts: {{productId: 13, productName: Konbu, category: Seafood, unitPrice: 6.0, unitsInStock: 24}}}
{Category: Condiments, CheapestProducts: {{productId: 3, productName: Aniseed Syrup, category: Condiments, unitPrice: 10.0, unitsInStock: 13}}}
{Category: Meat/Poultry, CheapestProducts: {{productId: 54, productName: Tourti�re, category: Meat/Poultry, unitPrice: 7.45, unitsInStock: 21}}}
{Category: Produce, CheapestProducts: {{productId: 74, productName: Longlife Tofu, category: Produce, unitPrice: 10.0, unitsInStock: 4}}}
{Category: Beverages, CheapestProducts: {{productId: 24, productName: Guaran� Fant�stica, category: Beverages, unitPrice: 4.5, unitsInStock: 20}}}
This sample gets the highest number in an array. Note that the method returns a single value.
//c#
static void Linq85()
{
var numbers = new []{ 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var maxNum = numbers.Max();
Console.WriteLine($"The maximum number is {maxNum}.");
}#python
def linq85():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
max_num = max(numbers)
print("The maximum number is %d." % max_num)The maximum number is 9.
This sample gets the length of the longest word in an array.
//c#
static void Linq86()
{
var words = new [] { "cherry", "apple", "blueberry" };
var longestLength = words.Max(w => w.Length);
Console.WriteLine($"The longest word is {longestLength} characters long.");
}#python
def linq86():
words = ["cherry", "apple", "blueberry"]
longest_word = max(len(w) for w in words)
print("The longest word is %d characters long." % longest_word)The longest word is 9 characters long.
This sample gets the most expensive price among each category's products.
//c#
static void Linq87()
{
var products = GetProductList();
var categories = products
.GroupBy(prod => prod.Category)
.Select(prodGroup =>
new
{
Category = prodGroup.Key,
MostExpensivePrice = prodGroup.Max(p => p.UnitPrice)
});
ObjectDumper.Write(categories);
}#python
def linq87():
products = shared.getProductList()
sorted_by_category = sorted(products, key=lambda p: p.Category)
grouped_by_category = groupby(sorted_by_category, key=lambda p: p.Category)
category_expensive_price = map(
lambda g: SimpleNamespace(Category=g[0],
MostExpensive=max(p.UnitPrice for p in g[1])),
grouped_by_category)
shared.print_namespace(category_expensive_price){Category: Dairy Products, MostExpensivePrice: 55.0}
{Category: Grains/Cereals, MostExpensivePrice: 38.0}
{Category: Confections, MostExpensivePrice: 81.0}
{Category: Seafood, MostExpensivePrice: 62.5}
{Category: Condiments, MostExpensivePrice: 43.9}
{Category: Meat/Poultry, MostExpensivePrice: 123.79}
{Category: Produce, MostExpensivePrice: 53.0}
{Category: Beverages, MostExpensivePrice: 263.5}
This sample gets the products with the most expensive price in each category.
//c#
static void Linq88()
{
var products = GetProductList();
var categories = products.GroupBy(prod => prod.Category)
.Select(prodGroup => new {prodGroup, maxPrice = prodGroup.Max(p => p.UnitPrice)})
.Select(x =>
new
{
Category = x.prodGroup.Key,
MostExpensiveProducts = x.prodGroup.Where(p => p.UnitPrice == x.maxPrice)
});
ObjectDumper.Write(categories, 1);
}#python
def linq88():
pass{Category: Dairy Products, MostExpensiveProducts: {{productId: 59, productName: Raclette Courdavault, category: Dairy Products, unitPrice: 55.0, unitsInStock: 79}}}
{Category: Grains/Cereals, MostExpensiveProducts: {{productId: 56, productName: Gnocchi di nonna Alice, category: Grains/Cereals, unitPrice: 38.0, unitsInStock: 21}}}
{Category: Confections, MostExpensiveProducts: {{productId: 20, productName: Sir Rodney's Marmalade, category: Confections, unitPrice: 81.0, unitsInStock: 40}}}
{Category: Seafood, MostExpensiveProducts: {{productId: 18, productName: Carnarvon Tigers, category: Seafood, unitPrice: 62.5, unitsInStock: 42}}}
{Category: Condiments, MostExpensiveProducts: {{productId: 63, productName: Vegie-spread, category: Condiments, unitPrice: 43.9, unitsInStock: 24}}}
{Category: Meat/Poultry, MostExpensiveProducts: {{productId: 29, productName: Th�ringer Rostbratwurst, category: Meat/Poultry, unitPrice: 123.79, unitsInStock: 0}}}
{Category: Produce, MostExpensiveProducts: {{productId: 51, productName: Manjimup Dried Apples, category: Produce, unitPrice: 53.0, unitsInStock: 20}}}
{Category: Beverages, MostExpensiveProducts: {{productId: 38, productName: C�te de Blaye, category: Beverages, unitPrice: 263.5, unitsInStock: 17}}}
This sample gets the average of all numbers in an array.
//c#
static void Linq89()
{
var numbers = new [] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var averageNum = numbers.Average();
Console.WriteLine($"The average number is {averageNum}.");
}#python
def linq89():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
average_num = sum(numbers) / float(len(numbers))
print("The average number is %f." % average_num)The average number is 4.5.
This sample gets the average length of the words in the array.
//c#
static void Linq90()
{
var words = new [] { "cherry", "apple", "blueberry" };
var averageLength = words.Average(w => w.Length);
Console.WriteLine($"The average word length is {averageLength} characters.");
}#python
def linq90():
words = ["cherry", "apple", "blueberry"]
average_length = sum(len(w) for w in words) / float(len(words))
print("The average word length is %f characters." % average_length)The average word length is 6.666666666666667 characters.
This sample gets the average price of each category's products.
//c#
static void Linq91()
{
var products = GetProductList();
var categories = products
.GroupBy(prod => prod.Category)
.Select(prodGroup =>
new
{
Category = prodGroup.Key,
AveragePrice = prodGroup.Average(p => p.UnitPrice)
});
ObjectDumper.Write(categories);
}#python
def linq91():
pass{Category: Dairy Products, AveragePrice: 28.73}
{Category: Grains/Cereals, AveragePrice: 20.25}
{Category: Confections, AveragePrice: 25.16}
{Category: Seafood, AveragePrice: 20.6825}
{Category: Condiments, AveragePrice: 23.0625}
{Category: Meat/Poultry, AveragePrice: 54.00666666666667}
{Category: Produce, AveragePrice: 32.37}
{Category: Beverages, AveragePrice: 37.979166666666664}
This sample uses creates a running product on the array that calculates the total product of all elements.
//c#
static void Linq92()
{
var doubles = new [] { 1.7, 2.3, 1.9, 4.1, 2.9 };
var product = doubles.Aggregate((runningProduct, nextFactor) => runningProduct * nextFactor);
Console.WriteLine($"Total product of all numbers: {product}");
}#python
def linq92():
doubles = [1.7, 2.3, 1.9, 4.1, 2.9]
product = reduce(operator.mul, doubles)
#or
#product = reduce(lambda running_product, next_factor: running_product * next_factor, doubles)
print("Total product of all numbers: %f" % product)Total product of all numbers: 88.33080999999999
This sample uses to creates a running account balance that subtracts each withdrawal from the initial balance of 100, as long as the balance never drops below 0.
//c#
static void Linq93()
{
var startBalance = 100.0;
var attemptedWithdrawals = new []{ 20, 10, 40, 50, 10, 70, 30 };
var endBalance = attemptedWithdrawals
.Aggregate(startBalance,
(balance, nextWithdrawal) =>
((nextWithdrawal <= balance) ? (balance - nextWithdrawal) : balance));
Console.WriteLine($"Ending balance: {endBalance}");
} #python
def linq93():
start_balance = 100.0
attempted_withdrawals = [20, 10, 40, 50, 10, 70, 30]
end_balance = reduce(
lambda runningBalance, nextWithDrawal: runningBalance - nextWithDrawal if nextWithDrawal <= runningBalance else runningBalance,
attempted_withdrawals,
start_balance)
print("Ending balance: %f" % end_balance)Ending balance: 20.0
This sample creates a contatenation of each array's values, one after the other.
//c#
static void Linq94()
{
int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };
int[] numbersB = { 1, 3, 5, 7, 8 };
var allNumbers = numbersA.Concat(numbersB);
Console.WriteLine("All numbers from both arrays:");
allNumbers.ForEach(Console.WriteLine);
}#python
def linq94():
numbers_a = [0, 2, 4, 5, 6, 8, 9]
numbers_b = [1, 3, 5, 7, 8]
all_numbers = numbers_a + numbers_b
print("All numbers from both arrays:")
shared.printN(all_numbers)All numbers from both arrays:
0
2
4
5
6
8
9
1
3
5
7
8
This sample creates a contatenation that contains the names of all customers and products, including any duplicates.
//c#
static void Linq95()
{
var customers = GetCustomerList();
var products = GetProductList();
var customerNames = customers.Select(cust => cust.CompanyName);
var productNames = products.Select(prod => prod.ProductName);
var allNames = customerNames.Concat(productNames);
Console.WriteLine("Customer and product names:");
allNames.ForEach(Console.WriteLine);
}#python
def linq95():
products = shared.getProductList()
customers = shared.getCustomerList()
customer_names = [p.ProductName for p in products]
product_names = [c.CompanyName for c in customers]
all_names = customer_names + product_names
print("Customer and product names:")
shared.printS(all_names)Customer and product names:
Alfreds Futterkiste
Ana Trujillo Emparedados y helados
Antonio Moreno Taquer�a
Around the Horn
Berglunds snabbk�p
Blauer See Delikatessen
...
This sample checks if two sequences match on all elements in the same order
//c#
static void Linq96()
{
var wordsA = new[] { "cherry", "apple", "blueberry" };
var wordsB = new[] { "cherry", "apple", "blueberry" };
var match = wordsA.SequenceEqual(wordsB);
Console.WriteLine($"The sequences match: {match}");
}#python
def linq96():
words_a = ["cherry", "apple", "blueberry"]
words_b = ["cherry", "apple", "blueberry"]
match = words_a == words_b
print("The sequences match: %s" % match)The sequences match: True
This sample checks if two sequences match on all elements in the same order.
//c#
static void Linq97()
{
var wordsA = new[] { "cherry", "apple", "blueberry" };
var wordsB = new[] { "apple", "blueberry", "cherry" };
var match = wordsA.SequenceEqual(wordsB);
Console.WriteLine($"The sequences match: {match}");
} #python
def linq97():
words_a = ["cherry", "apple", "blueberry"]
words_b = ["apple", "blueberry", "cherry"]
match = words_a == words_b
print("The sequences match: %s" % match)The sequences match: False
The following sample shows how query execution is deferred until the query is enumerated at a foreach statement.
//c#
static void Linq99()
{
// Queries are not executed until you enumerate over them.
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
int i = 0;
var simpleQuery = numbers
.Select(x => i++);
// The local variable 'i' is not incremented until the query is executed in the foreach loop.
Console.WriteLine($"The current value of i is {i}"); //i is still zero
simpleQuery.ForEach(item => Console.WriteLine($"v = {item}, i = {i}")); // now i is incremented
}#python
def linq99():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
i = 0
def add_to_i(n):
nonlocal i
i = i + 1
return n
q = map(add_to_i, numbers)
for v in q:
print("v = %d, i = %d" % (v, i))v = 1, i = 1
v = 2, i = 2
v = 3, i = 3
v = 4, i = 4
v = 5, i = 5
v = 6, i = 6
v = 7, i = 7
v = 8, i = 8
v = 9, i = 9
v = 10, i = 10
The following sample shows how queries can be executed immediately, and their results stored in memory, with methods such as ToList/list.
//c#
static void Linq100()
{
// Methods like ToList(), Max(), and Count() cause the query to be executed immediately.
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var i = 0;
var immediateQuery = numbers
.Select(x => ++i)
.ToList();
Console.WriteLine("The current value of i is {0}", i); //i has been incremented
immediateQuery.ForEach(item => Console.WriteLine($"v = {item}, i = {i}"));
}#python
def linq100():
numbers = [5, 4, 1, 3, 9, 8, 6, 7, 2, 0]
i = 0
def add_to_i(n):
nonlocal i
i = i + 1
return n
q = list(map(add_to_i, numbers))
for v in q:
print("v = %d, i = %d" % (v, i))v = 1, i = 10
v = 2, i = 10
v = 3, i = 10
v = 4, i = 10
v = 5, i = 10
v = 6, i = 10
v = 7, i = 10
v = 8, i = 10
v = 9, i = 10
v = 10, i = 10
The following sample shows how, because of deferred execution, queries can be used again after data changes and will then operate on the new data.
//c#
static void Linq101()
{
// Deferred execution lets us define a query once and then reuse it later in various ways.
var numbers = new[] { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var lowNumbers = numbers
.Where(num => num <= 3);
Console.WriteLine("First run numbers <= 3:");
lowNumbers.ForEach(Console.WriteLine);
// Modify the source data.
for (var i = 0; i < 10; i++)
{
numbers[i] = -numbers[i];
}
// During this second run, the same query object,
// lowNumbers, will be iterating over the new state
// of numbers[], producing different results:
Console.WriteLine("Second run numbers <= 3:");
lowNumbers.ForEach(Console.WriteLine);
} #python
def linq101():
passFirst run numbers <= 3:
1
3
2
0
Second run numbers <= 3:
-5
-4
-1
-3
-9
-8
-6
-7
-2
0