Thread: Easy App CSV

Hi guys, thank you in advance for the help that you give me, I'll explain my situation.
I comed from Android but I'm a newbie in programming in general.
I am now in contact with Java.
I have to develop an app that given as input a CSV file with 6 fields such as fact:

Keyword, Competitor, Search Engine, Position, Web Page, Changes,
beer, 27300000, Google Universal Italy, 1, wikipedia, +,
beer, 27300000, Google Universal Italy, 2, birra, +,
beer, 27300000, Google Universal Italy, 3, albanesi, +
ale, 7300000, Google Universal Italy, 1, wikipedia, +,
ale, 7300000, Google Universal Italy, 2, birra, +,
ale, 7300000, Google Universal Italy, 3, albanesi, +
dark beer, 300000, Google Universal Italy, 1, wikipedia, +,
dark beer, 300000, Google Universal Italy, 2, birra, +,
dark beer, 300000, Google Universal Italy, 3, albanesi, +



face a ranking by assigning a score to each domain based on the position in the standings and finally the final classification by the sum of the rankings for each key.

for example
Keyword Domination Score
beer, Wikipedia, 30
beer, Birra, 20
beer, Albanesi, 10

etc. etc.

final Standings
Domination Score
Wikipedia, 90
Birra, 40
Albanesi, 30

The output file must be CSV.
I hope I was clear enough and thank you again.

What have you tried? - Matt Gemmell

Nobody will do it for you. Post your best attempt and ask specific questions.

I understand how to read a CSV but I do not understand how to be able to assign scores and do the ranking, I have to use a database or can I do without it?
[
import java.io.*;
import java.util.Arrays;

public class CSVRead{

public static void main(String[] arg) throws Exception {

BufferedReader CSVFile = new BufferedReader(new FileReader("C:\\birra.csv"));

String dataRow = CSVFile.readLine(); // Read the first line of data.
// The while checks to see if the data is null. If it is, we've hit
// the end of the file. If not, process the data.
while (dataRow != null){
String[] dataArray = dataRow.split(",");
for (String item:dataArray) { System.out.print(item + "\t"); }
System.out.println(); // Print the data line.
dataRow = CSVFile.readLine(); // Read next line of data.
}

// Close the file once all data has been read.
CSVFile.close();

// End the printout with a blank line.
System.out.println();

} //main()
} // CSVRead
]

You haven't specified how those scores should be calculated. You don't store the data from the csv file anywhere in memory, so there's nothing left to do calculations with.

Yeah I know that in my code I do not save the data, I do not know how to do it.
Scores are awarded based on the location field:
position 1 = 30 points
position 2 = 20 points ecc