dic = {'office': {'component_office': ['Word2010SP0', 'PowerPoint2010SP0']}}
"""INSERT INTO `db`.`table`(`ip_address`, `soft_data`) VALUES (`{}`, `{}`)""".format(
    '192.xxx.xx.xx', str(dic))
How to store python dictionary in to mysql DB through python