Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- command = 'Rscript'
- path_to_script = 'R/merging_tool.R'
- cmd = [command, path_to_script] + [self.ui.path.text(), str(self.ui.recalculate.isChecked()), str(self.ui.aggregate.isChecked()),
- str(self.ui.mad.isChecked()), str(self.ui.create_paid.isChecked()), str(self.ui.codierung.isChecked()), output_filename]
- subprocess.run(cmd, shell = True)
- merge_all = pandas.read_csv(self.ui.path.text() + "/" + output_filename + ".csv", sep = ";", decimal = ",", encoding = 'latin-1')
- writer = pandas.ExcelWriter(self.ui.path.text() + "/" + output_filename + ".xlsx", engine = 'xlsxwriter')
- merge_all.to_excel(writer, sheet_name = "MergeAll", index = False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement