Search Results

I'm able to do what I need, but it seems like there's always a better way. I have two lists, epiExcel and epiDB. Each has 3 columns and about 2,500 rows. I need to find out if the first 2 columns o …

I have a 2-dim array. The first 3 rows have column headings. The heading can be a single word, or 2 words (which take 2 rows) or 3 words (which take 3 rows). For each column I know which row has th …

I have a way to solve my problem, but it seems like there should be something better. Also I realize that I probably don't have a good enough handle on how to get at parts of lists the way I need to. …

I have 2 lists (of lists), where most of the contained lists match. That is, the lists contained in list1 mostly match the lists contained in list2. In this simplified example each of the inner list …

I have a list that looks like this: {{"a",},{2010,0},{2011,10},{2012,27},{"b",},{2011,11},{2012,66},{"c",},{2010,19},{2011,20},{2012,}} I want to turn it into: {{"a",2010,0},{"a",2011,10},{"a",201 …

If you meant to delete cases where there is only a pair of positive numbers: DeleteCases[M, {x_ /; x > 0, y_ /; y > 0}]

I have a list of pairs of values. Some of those pairs are invalid based on another list. I would like to select only the valid pairs. list1 = {"abc", "def", "ghi", "jkl", "mno"}; list2 = {{"abc", 1 …

I'd like to get the Min, Max, Median, Mean, etc. for the same list. For now I'm doing the following: y = {1, 2, 3, 4, 5, 6, 7}; Map[{Max[#] , Min[#] , Median[#], Mean[#]} &, y, {0}] It seems like …

(myMatrix[[#, #]] = 1) & /@ myIndices;

In my work I found that I needed the Extract function. However I was wondering if there was a way to use Part. Assume that mList is a 4-dim array. I did the following, which worked. x = {2, 10, 3, …

I have a list that includes dates. I need to convert each date to be the last day of the quarter that it's in. So for example I want {2013,7,1,0,0,0} to become {2013,9,30,0,0,0}. Actually I don't nee …

I have a cost that varies by category and date. I also have the counts of each item type within each category and date. I want to distribute the cost to each of the item types. I'm trying to use Gr …