Tag: Converting

[Python for Organic/Medicinal Chemistry] How You Can Play with Molecular Structures of Drugs in Python I. Drawing & Converting File Format

In this post, I will show you how to convert drug names into molecular structure, save into Excel, read into Python, display the structure, and convert file format. The motivation was really to batch process a large number of organic molecules in a specific way to support drug discovery. In an ef...

Converting Chinese characters to Pinyin or Jyutping on Google Sheets

If you study Mandarin, you probably know what Pinyin is. In Cantonese, Jyutping fulfills a similar role. Dictionaries will show you the Pinyin for individual words, but if you want to quickly convert whole sentences, such as when taking notes during a Chinese lesson, you need better tools.  ...

Converting Chinese Characters to Pinyin/Jyutping on Google Sheets: now with more functionality

You can now pass a range of cells or a whole column to the PINYIN() / JYUTPING() fuctions, for example: PINYIN(A1:A20) this will convert cells A1 through A20 PINYIN(A:A) this will convert any chinese text present in column A. It will keep on converting as you add new rows in column...