os_lab1_5

import java.util.*;
import java.io.*;
import java.text.DecimalFormat;
import java.text.NumberFormat;

public class JavaIOLab5 {

	public static void main(String[] args) throws IOException {

		BufferedReader in = null;
		BufferedWriter out = null;


		try
		{
			in = new BufferedReader(new FileReader("rezultati.txt"));
			out = new BufferedWriter(new FileWriter("formatiran.tsv"));

			String line;
			while((line=in.readLine())!=null)
			{
				String tabLine = line.replaceAll(",", "\t");

				out.write(tabLine);
				out.newLine();


			}
			in.close();
			in=new BufferedReader(new FileReader("rezultati.txt"));
			out.close();
			out = new BufferedWriter(new FileWriter("prosek.txt"));


			String [] title;
			line = in.readLine();
			title=line.split(",");
			out.write(line.replaceAll(",","\t")+" "+" prosek");
			String student;
			float suma=0;
			float prosek =0;
			StringBuilder sb = new StringBuilder();

			while((line=in.readLine())!=null)
			{
				suma=0;
				sb=new StringBuilder();
				String p=line;
				String []temp=p.split(",");
				student = temp[0];
				for(int i=1;i<temp.length;i++)
				{
					suma=suma+Integer.parseInt(temp[i]);


				}
				sb.append(line.replaceAll(",", "\t"));
				prosek=suma/(temp.length-1);
				NumberFormat formater = new DecimalFormat("#0.00");

				sb.append("\t"+"("+ formater.format(prosek) +")");
				out.newLine();
				out.write(sb.toString());



			}

			in.close();
			in=new BufferedReader(new FileReader("rezultati.txt"));//dali mora na seko ako sakam
																  //od pocetok da citam od fajl vaka da pravam
			line = in.readLine();
			String []predmeti = line.split(",");
			String predmetiTitle="";
			for(int i=1;i<predmeti.length;i++)
			{
				predmetiTitle+=predmeti[i]+"\t";


			}
			out.newLine();
			out.write("_______________________________");
			out.newLine();
			out.write("PROSEK PO PREDMET");
			out.newLine();
			out.write(predmetiTitle);

			int brojPredmeti=predmeti.length-1;

			int brojStudenti =0;
			float [] ocenkiPoPredmet = new float[brojPredmeti];
			for(int i=0;i<ocenkiPoPredmet.length;i++)
			{
				ocenkiPoPredmet[i]=0;
			}
			while((line=in.readLine())!=null)
			{
				String []pom=line.split(",");
				for(int i=1;i<pom.length;i++)
				{
					ocenkiPoPredmet[i-1]+=Integer.parseInt(pom[i]);

				}
				brojStudenti++;
			}

			StringBuilder build = new StringBuilder();
			for(int i=0;i<ocenkiPoPredmet.length;i++)
			{
				ocenkiPoPredmet[i]=ocenkiPoPredmet[i]/brojStudenti;
				build.append(ocenkiPoPredmet[i]+"\t");
			}
			out.newLine();
			out.write(build.toString());

		}
		finally
		{
			if(in!=null)
			{
				in.close();
			}
			if(out!=null)
			{
				out.close();
			}
		}
	}

}