A Nobel laureate has apologised for any offence caused by comments about the “trouble with girls” involved in science.