CSVReader

 avatar
unknown
java
4 years ago
4.7 kB
7
Indexable
  pathtwo="/Users/Mariana/Documents/CSC365Fall/Project1/2020VAERSDataText.txt";
        linetwo="";
        FileWriter fwtwo=new FileWriter("/Users/Mariana/Documents/CSC365Fall/Project1/2020CovidVAERS.txt",true);
        PrintWriter outtwo=new PrintWriter(fwtwo);

        try {
            BufferedReader brtwo = new BufferedReader(new FileReader(pathtwo));
            linetwo = brtwo.readLine();
            System.out.println("linetwo"+linetwo);

            while ((linetwo = brtwo.readLine()) != null) {
                int idtwo = 0;
                String receiveddate = "";
                String state = "";
                double age= 0;
                int cage_yrs = 0;
                String cage_month = "";
                String sex = "";
                String rpt_dates = "";
                String symptom_test = "";
                String died = "";
                String datedied = "";
                String l_threat = "";
                String er_visit = "";
                String hospital = "";
                String hospdays = "";
                String x_stays = "";
                String disable = "";
                String recovd = "";
                String vax_date = "";
                String onset_date = "";
                String numdays = "";
                String lab_data = "";
                String v_adminby = "";
                String v_fundby = "";
                String other_meds = "";
                String cur_ill = "";
                String history = "";
                String prior_vax = "";
                String splttype = "";
                String form_vers = "";
                String todays_date = "";
                String birth_defect = "";
                String ofc_visit = "";
                String er_ed_visit = "";
                String allergies = "";
              //  String[] valuetwo = linetwo.split(",");
                String[] tokens=linetwo.split(",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)",-1);



                idtwo = Integer.parseInt(tokens[0]);
              //  System.out.println("id"+":"+idtwo);
                receiveddate = tokens[1];
                state = tokens[2];
                age = Double.parseDouble(tokens[3]);
              // System.out.println("age"+age);
                cage_yrs = Integer.parseInt(tokens[4]);
                //System.out.println("cage_trs"+":"+cage_yrs);
                cage_month = tokens[5];
                sex = tokens[6];
                rpt_dates = tokens[7];
                symptom_test = tokens[8];
            //    System.out.println("symptomtest"+":"+symptom_test);
                died = tokens[9];
                datedied = tokens[10];
                l_threat = tokens[11];
                er_visit = tokens[12];
                hospital = tokens[13];
                hospdays = tokens[14];
                x_stays = tokens[15];
                disable = tokens[16];
                recovd = tokens[17];
                vax_date = tokens[18];
                onset_date = tokens[19];
                numdays = tokens[20];
                lab_data = tokens[21];
                v_adminby = tokens[22];
                v_fundby = tokens[23];
                other_meds = tokens[24];
                cur_ill = tokens[25];
                history = tokens[26];
                prior_vax = tokens[27];
                splttype = tokens[28];
                form_vers = tokens[29];
                todays_date = tokens[30];
                birth_defect = tokens[31];
                ofc_visit = tokens[32];
                er_ed_visit = tokens[33];
                allergies = tokens[34];
                currentvearsdata = new VAERSData(idtwo, receiveddate, state, age, cage_yrs, cage_month, sex, rpt_dates, symptom_test, died, datedied, l_threat, er_visit, hospital, hospdays, x_stays, disable, recovd, vax_date, onset_date, numdays, lab_data, v_adminby, v_fundby, other_meds, cur_ill, history, prior_vax, splttype, form_vers, todays_date, birth_defect, ofc_visit, er_ed_visit, allergies);
                //System.out.println("tokens"+currentvearsdata.toString());

                vaersdata.add(currentvearsdata);
              // linetwo= brtwo.readLine(); commented this because it skipped the line




            }
            System.out.println(vaersdata.size());
            for(VAERSData d:vaersdata){
                outtwo.println(d.toString());
            }
            outtwo.close();





        } catch (IOException e) {
            e.printStackTrace();
        } catch (NumberFormatException m) {
            m.printStackTrace();
        }
Editor is loading...