def test_long(df_long, wide_to_long):
melted = wide_to_long(
dataframe=df_long,
value_columns=hlp.string_to_list(
'PHT, PF, KRF, RBF, SDUNK, SDP, SDKR, SDRD, SDAN'),
value_column_name='cover')
assert (
hlp.string_to_list('PHT, PF, KRF, RBF, SDUNK, SDP, SDKR, SDRD, SDAN')
== melted['species_column'].drop_duplicates().values.tolist()) is True
def covar_handle5():
covarlned = {'columns': None}
covarlned['columns'] = string_to_list('TEMP, TAG')
covarini = ini.InputHandler(name='covarinfo',
tablename='covartable',
lnedentry=covarlned)
return covarini
def covar_handle_3_biomass():
covarlned = {'columns': None}
covarlned['columns'] = string_to_list('temp')
covarini = ini.InputHandler(name='covarinfo',
tablename='covartable',
lnedentry=covarlned)
return covarini
def covar_handle_4_percent_cover():
covarlned = {'columns': None}
covarlned['columns'] = string_to_list('Precip')
covarini = ini.InputHandler(name='covarinfo',
tablename='covartable',
lnedentry=covarlned)
return covarini
def covar_handle_2_density():
covarlned = {'columns': None}
covarlned['columns'] = string_to_list('AREA, VIS, OBS_CODE')
covarini = ini.InputHandler(name='covarinfo',
tablename='covartable',
lnedentry=covarlned)
return covarini
def covar_handle2():
covarlned = {"columns": None}
covarlned["columns"] = string_to_list("temp")
covarini = ini.InputHandler(name="covarinfo", tablename="covartable", lnedentry=covarlned)
return covarini
def submit_change(self):
sender = self.sender()
self.widetolonglned = {
'value_columns':
hlp.string_to_list(self.lnedValuecolumns.text()),
'datatype_name': self.cboxDatatypecolumn.currentText(),
'panel_data': self.ckPaneldata.isChecked()
}
self.widetolongini = ini.InputHandler(
name='widetolong', lnedentry=self.widetolonglned)
self.facade.input_register(self.widetolongini)
self.facade.create_log_record('widetolong')
self._log = self.facade._tablelog['widetolong']
try:
if self.widetolonglned['panel_data'] is False:
self.widetolongtable = hlp.wide_to_long(
self.facade._data,
value_columns=self.widetolonglned['value_columns'],
value_column_name=self.widetolonglned['datatype_name'])
else:
temp = self.facade._data.copy()
temp['id'] = temp.index
self.widetolongtable = wide_to_long(
temp,
self.widetolonglned['value_columns'],
i="id",
j=self.widetolonglned['datatype_name'])
self.widetolongtable[self.widetolonglned[
'datatype_name']] = self.widetolongtable.index.get_level_values(
self.widetolonglned['datatype_name'])
self.widetolongtable.reset_index(drop=True, inplace=True)
except Exception as e:
print(str(e))
self.error.showMessage('Could not melt data: ', str(e))
try:
assert self.widetolonglned['datatype_name'] != 'NULL'
except Exception as e:
print(str(e))
self.error.showMessage('Invalid datatype column: ' + str(e))
return
if sender is self.btnPreview:
self.widetolongmodel = view.PandasTableModel(
self.widetolongtable)
self.preview.tabviewPreview.setModel(self.widetolongmodel)
self.preview.show()
elif sender is self.btnSaveClose:
hlp.write_column_to_log(self.widetolonglned, self._log,
'widetolong')
self.facade._data = self.widetolongtable
self.update_data.emit('update')
self.close()
def submit_change(self):
sender = self.sender()
self.covarlned['columns'] = hlp.string_to_list(
self.lnedColumns.text()
)
self.covarini = ini.InputHandler(
name='covarinfo', tablename='covartable',
lnedentry=self.covarlned)
self.facade.input_register(self.covarini)
self.facade.create_log_record('covartable')
self._log = self.facade._tablelog['covartable']
if self.covarlned['columns'][0] == '':
print('in pass')
pass
else:
try:
self.facade._data[self.covarlned['columns']]
except Exception as e:
print(str(e))
self._log.debug(str(e))
self.error.showMessage(
'Column names not valid: Check spacing ' +
'and headers.')
raise ValueError('Column names are incorrect')
try:
self.covardata = ddf.DictionaryDataframe(
self.facade._data, self.covarlned['columns']
).convert_records()
except Exception as e:
print(str(e))
self._log.debug(str(e))
self.error.showMessage('Could not concatenate columns')
raise TypeError('Could not concatenate columns')
self.facade.push_tables['covariates'] = self.covardata
if sender is self.btnColumns:
self.message.about(self, 'Status', 'Columns recorded')
elif sender is self.btnPreview:
self.covarmodel = views.PandasTableModelEdit(
self.covardata)
self.preview.tabviewPreview.setModel(self.covarmodel)
self.preview.show()
elif sender is self.btnSaveClose:
hlp.write_column_to_log(
self.covarlned, self._log, 'covartable')
self.close()
def submit_change(self):
sender = self.sender()
self.widetolonglned = {
'value_columns':
hlp.string_to_list(self.lnedValuecolumns.text()),
'datatype_name': self.cboxDatatypecolumn.currentText()
}
self.widetolongini = ini.InputHandler(
name='widetolong',
lnedentry=self.widetolonglned
)
self.facade.input_register(self.widetolongini)
self.facade.create_log_record('widetolong')
self._log = self.facade._tablelog['widetolong']
try:
self.widetolongtable = hlp.wide_to_long(
self.facade._data,
value_columns=self.widetolonglned['value_columns'],
value_column_name=self.widetolonglned['datatype_name']
)
except Exception as e:
print(str(e))
self.error.showMessage('Could not melt data: ', str(e))
try:
assert self.widetolonglned['datatype_name'] != 'NULL'
except Exception as e:
print(str(e))
self.error.showMessage(
'Invalid datatype column: ' + str(e))
return
hlp.write_column_to_log(
self.widetolonglned, self._log, 'widetolong')
if sender is self.btnPreview:
self.widetolongmodel = view.PandasTableModel(
self.widetolongtable)
self.preview.tabviewPreview.setModel(
self.widetolongmodel)
self.preview.show()
elif sender is self.btnSaveClose:
self.facade._data = self.widetolongtable
self.update_data.emit('update')
self.close()
def submit_change(self):
sender = self.sender()
self.covarlned['columns'] = hlp.string_to_list(self.lnedColumns.text())
self.covarini = ini.InputHandler(name='covarinfo',
tablename='covartable',
lnedentry=self.covarlned)
self.facade.input_register(self.covarini)
self.facade.create_log_record('covartable')
self._log = self.facade._tablelog['covartable']
if self.covarlned['columns'][0] == '':
print('in pass')
pass
else:
try:
self.facade._data[self.covarlned['columns']]
except Exception as e:
print(str(e))
self._log.debug(str(e))
self.error.showMessage(
'Column names not valid: Check spacing ' + 'and headers.')
raise ValueError('Column names are incorrect')
try:
self.covardata = ddf.DictionaryDataframe(
self.facade._data,
self.covarlned['columns']).convert_records()
except Exception as e:
print(str(e))
self._log.debug(str(e))
self.error.showMessage('Could not concatenate columns')
raise TypeError('Could not concatenate columns')
self.facade.push_tables['covariates'] = self.covardata
if sender is self.btnColumns:
self.message.about(self, 'Status', 'Columns recorded')
elif sender is self.btnPreview:
self.covarmodel = views.PandasTableModelEdit(self.covardata)
self.preview.tabviewPreview.setModel(self.covarmodel)
self.preview.show()
elif sender is self.btnSaveClose:
hlp.write_column_to_log(self.covarlned, self._log, 'covartable')
self.close()
def covar_handle_2_density():
covarlned = {"columns": None}
covarlned["columns"] = string_to_list("AREA, VIS, OBS_CODE")
covarini = ini.InputHandler(name="covarinfo", tablename="covartable", lnedentry=covarlned)
return covarini
