Skip to main content

Collections

Collection Classes

From the last two week's labs you may have already identified some issues related to arrays. We learnt that arrays holds identically typed items. However there are instances when you may requires a more flexible data structure that is capable of growing dynamically without throwing an exception (IndexOutOfRangeException) as in the case of an array. .NET framework's System.Collection classes provides a number of builtIn data structures that are dynamic and typesafe. Some of these classes are generic and others are non-Generic. Generic classes are more typesafe and requires a "type parameter" to be specified. Whereas, the non-generic classes are very loosely typed and should be avoided if possible.

Non-Generic Classes

System.Collections namespace consists of following non generic classes:
  • ArrayList
  • Queue
  • Stack
  • HashTable
  • SortedList
  • BitArray
Issues related to non-generic classes: 
  • Slower executions speed: Can be slower due to memory transfer operations needed in Boxing and Unboxing. 
    • Boxing - Assigning a value type to a System.Object variable. CLR stores the objects on the heap 
    • Unboxing - Assigning a reference type to a value type variable. CLR checks ValueType variable being assigned is compatible and copies to a stack based variable. Unlike typical casting, appropriate data types should be used for value type variable or InvalidCastException is thrown. Therefore, the unboxing should be done with in a try/catch block.
  • Type safety issues: Can be used to store anything since it stores Objects. 
ArrayList Class
ArrayList is the dynamic collection of objects that are listed in a sequential order. ArrayList implements IList, ICollection, IEnumerable, and IClonable interfaces. ArrayList can resize itself to store more items and items can be added and removed from the ArrayList on the fly. Some useful methods of ArrayList class are given below: 
  • Add()
  • AddRange()
  • Insert()
  • Remove()
  • Count() 
  • Clear()
Links 

Generic Classes


Generic classes solves all issues related to non-generic classes mentioned above which includes performance issue and type safety issues. Generic class requires a type parameter to create an instance of the generic class. Type parameter specified cannot be changed later. 
System.Collections.Generic namespace consists of following non generic classes:
  • List<T>
  • Queue<T>
  • Stack<T>
  • LinkedList<T>
  • SortedSet<T>
  • Dictionary<TKey, TValue>
  • SortedDictionary<TKey, TValue>
List<T> class
List<T> is a automaticially resizing collection of sequencially listed items of type T. List<T> implements ICollection<T>, IEnumerable<T> and IList<T> interfaces.

            List<Student> people = new List<Student>()            {
            new Student ("John", "Paul", 74),
            new Student ("Sean", "Smith",45),
            new Student ("Jane", "Donald", 90),
            new Student ("Jessi", "John", 86)           
}; 

Links

Comments

Popular posts from this blog

CUMIPMT and CUMPRINC function

CUMIPMT Cumulative interest payment function allows you to calculate the interest paid for a loan or from an investment from period A to period B. When getting a loan, CUMIPMT function can be used to calculate the total amount of interest paid in the first five months or from period 12 to period 20. A period can be a month, a week or two week. Loan Amount : 350,000.00 APR: 4.5% Down payment: 0.00 Years: 25 Payment per year: 12 From the above data, we can calculate the following: No of Period: 25 × 12 = 300 Periodic Rate: 4.5/12 = 0.375% Here is how you will substitute these values into the function. = CUMIPMT (periodic rate, No of period, vehicle price, start period, end period,  ) = CUMIPMT (0.375, 300, 350000, 1, 5, 0) In an excel worksheet, we use cell address instead of actual values as shown below: Here is the formula view of the worksheet: CUMPRINC Another related function is CUMPRINC. CUMPRINC function is used to calculate cumul

Excel PMT Function

PMT function is very useful for calculating monthly payment required to payback a loan or mortgage at a fixed rate. This function require a minimum of three inputs, periodic rate, number of periods, present value or the loan amount. Here is a simple example. Home Loan: 350,000.00 Interest rate: 4.5% Number of years to repay the loan: 25 Note: To calculate monthly payment, we need to find the monthly rate and number of months as shown above. Then it is simply a matter of substituting the values into the payment function, as shown in the formula view below.

BCG's Brand Advocacy Index

The Boston Consulting Group's (BCG) Brand Advocacy Index (BAI) is a metric developed to help companies measure the degree of customer advocacy for their brands. BAI focuses on the likelihood of customers to recommend a brand to others, which is a powerful indicator of brand strength and customer loyalty. Unlike other customer satisfaction or loyalty metrics, BAI emphasizes the importance of customer referrals and word-of-mouth marketing. BAI is calculated based on a survey where customers are asked about their willingness to recommend a brand to their friends, family, or colleagues. The responses are then used to compute a score, which ranges from -100 to 100. A higher BAI score indicates that a brand has more advocates who are likely to recommend the brand to others, while a lower score suggests that the brand has fewer advocates or even a higher number of detractors. BCG's research has shown that companies with higher BAI scores tend to experience higher growth rates and bett