tencentcloud-hosts-ansible.py

#!/usr/bin/env python

import sys
import pandas as pd

df = pd.read_csv(sys.argv[1])

last = ''
for row in df[df['Vpc名称'].notna()][df['主IPv4公网IP'].notna()].sort_values(by=['Vpc名称']).iterrows():
     if last != row[1]['Vpc名称']:
         print()
         print('[' + row[1]['Vpc名称'] + ']')
         last = row[1]['Vpc名称']
     print(row[1]['ID'], 'ansible_host=' + row[1]['主IPv4公网IP'], '\t#', row[1]['实例名'], row[1]['主IPv4内网IP'])