Are there databases to query Chemical and Physical Properties of drugs or compounds with the input of drugs or compounds names? And then maybe do something like clustering? I'd want to check are there some common attributes for a list of drugs or compounds finally. Thank you.
The Wikidata chemistry community is adding more and more physchem properties for, now, something like 170 thousand compounds. Furthermore, it has many links out to other databases. The SQID interface provides a nice GUI, e.g. for acetic acid. Importantly, Wikidata has a strong reference system, ensuring that many properties values are linked to the (primary) data sources. In the SQID interface, notice the grey "arrows" in the top right next to the property.