Looping over a function with several parameters

Question

Folks I am a beginner in Mathematica and have a simple question regarding loops: Here's the problem, I have a dataset of with four columns and I need to loop over each row. So the matrix in which my data is has dimensions of n*4, (n rows).

If there was only one column then the problem is straightforward: I would do something like,

For[i=1;x=0, i < n; i++, x = custF[i];Print[x]]

where custF is custom function I built.

The problem is the function I built has four parameters not one. What I need is a loop like ForEach, which loops over each row and finds values of the function with all 4 parameters. Any help would be deeply appreciated!

Answer 1

Example:

(*Arbitrary data*) 
list = RandomInteger[{1, 10}, {4, 4}]

(*Apply list to custom function*)
f @@@ list

Output:

{f[2, 8, 6, 5], f[3, 1, 6, 7], f[9, 2, 10, 5], f[9, 2, 5, 9]}

EDIT

If you are loading an Excel spreadsheet, to apply row by row you could do something similar as described above.

In order to load up an Excel spreadsheet, see example below:

Example:

(*Import it into Mathematica*)
data =  Flatten[Import["C:\\Users\\-e\\Documents\\data.xlsx"], 1]

I use Flatten to remove additional {}

Output:

{{1., 2., 3., 4.}, {3., 4., 5., 5.}, {7., 8., 7., 1.}, {4., 7., 3., 6.}}

Then carry out same operation as in first example:

f @@@ data

where f is your custom function which takes 4 arguments as an input and on the output of the above you should have something like:

{f[1., 2., 3., 4.], f[3., 4., 5., 5.], f[7., 8., 7., 1.], f[4., 7., 3., 6.]}

Reference:

Apply
Flatten
List Manipulation

Tutorial:

Import spreadsheet