openmolecules.org

 
Home » DataWarrior » Functionality » entering IC50s (or other data row by row)
entering IC50s (or other data row by row) [message #37] Thu, 22 January 2015 02:27 Go to next message
mvamos is currently offline  mvamos
Messages: 24
Registered: January 2015
Location: US
Junior Member
First off, thank you for making this software available to all. As far as free software goes, it's probably the best around. I'm trying to use it to aid my research--med chemist at a nonprofit research institute.

I'm trying to load some data that I previously had stored in Excel into DW. I've loaded structures via SD file (from ChemDraw). But IC50s have proven very difficult to enter. I tried for quite awhile to find a way to automate it using merge/append/paste functions to no avail. It certainly would be nice to be able to paste directly from Excel or another DW column/row into DW.

I've decided I basically have to enter each one, one-by-one. However, the method for doing this in the current version (4.0.1) is quite tedious. I thought I could highlight the row I wanted to modify and simply type the value. Alas, I cannot. It seems I have to right click>Edit then enter the value and click ok. Perhaps this might make for a good change in the next version?
Re: entering IC50s (or other data row by row) [message #42 is a reply to message #37] Thu, 29 January 2015 21:59 Go to previous message
thomas is currently offline  thomas
Messages: 646
Registered: June 2014
Senior Member
Hallo,

first my appologies for the late answer. For some reason I sometimes don't get notification mails.

The easiest way to get data from Excel into DW is to select and copy rows and columns of an Excel sheet and choose then
choose 'Paste' in DataWarrior. That should create a new DataWarrior window with the data as content. DataWarrior tries to
recognize, whether the first column is a title column, e.g. by checking for every column whether all except the first column can be interpreted numerically. Ideally the Excel data contains a column with structure identifiers, which are also available
in the SD-File. If the SD-File contains every structure only once, then you can directly read the structures from the SD-file
into the data from Excel. If the SD-file contains the same structure multiple times, then you need to open the SD-file
separately, remove redundant (based on the structure) rows from the Data menu and save as a dwar file. Now you should be able
to merge this file from the window with the excel data.

The opposite order should work as well, provided that the Excel data contains every structure identifier only once:
Create a dwar file from the excel data with copy/paste. Open the SD-file and merge the excel.dwar file into it by
assigning the identifier column of the excel file to the one of the open sd-file and using it as merge key.

Important: For numerical columns to be perceived numerical, none of the cells should contain starting or trailing spaces or
other content that is not numerical. Allowed are empty cells, values starting with modifiers (<, <=, >, >=), multiple values separated by '; ' (semicolon plus one space), 'NaN' and '?'

I hope I could help. Otherwise, you may send me small demo files, which don't work that I can learn what the problem is.

Kind regards,

Thomas
Previous Topic: System clipboard
Next Topic: SOM generation.
Goto Forum:
  


Current Time: Thu Mar 28 23:29:32 CET 2024

Total time taken to generate the page: 0.08196 seconds