Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.73 KB | None | 0 0
  1.   command = 'Rscript'
  2.         path_to_script = 'R/merging_tool.R'
  3.         cmd = [command, path_to_script] + [self.ui.path.text(), str(self.ui.recalculate.isChecked()), str(self.ui.aggregate.isChecked()),
  4.                                            str(self.ui.mad.isChecked()), str(self.ui.create_paid.isChecked()), str(self.ui.codierung.isChecked()), output_filename]
  5.         subprocess.run(cmd, shell = True)
  6.  
  7.         merge_all = pandas.read_csv(self.ui.path.text() + "/" + output_filename + ".csv", sep = ";", decimal = ",", encoding = 'latin-1')
  8.         writer = pandas.ExcelWriter(self.ui.path.text() + "/" + output_filename + ".xlsx", engine = 'xlsxwriter')
  9.         merge_all.to_excel(writer, sheet_name = "MergeAll", index = False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement