kw_tools/choozmo/ads_csv_local.py

import csv
import sys
import codecs
import pandas as pd

with codecs.open('/Users/zooeytsai/Documents/220704有夠讚地標廣告.csv', 'r', 'utf-16') as csvfile:
    spamreader = csv.reader(csvfile, delimiter='\t', quotechar='|')
    # df = pd.read_csv('/Users/zooeytsai/Documents/220628有夠讚GDN.csv', encoding='utf16')
    kwdict = {}
    addict = {}
    campagindict = {}
    d = {}
    head = True
    for row in spamreader:
        # print(row)
        if head:
            head = False
            continue
        ll = len(row)
        campaign = row[0]
        adgroup = row[18]
        # print(adgroup)
        # print(adgroup)
        # kw = row[47]

        # if len(kw) > 0:
            # print(campaign)
            # print(adgroup)
        if kwdict.get(adgroup) is None:
            kwdict[adgroup] = []
        if addict.get(adgroup) is None:
            addict[adgroup] = []
        if d.get(adgroup) is None:
            d[adgroup] = []
        # kwdict[adgroup].append(kw)

        for i in range(54, 59): #headline
            hline = row[i]
            # print(hline)
            if len(hline) > 0:
                # print(addict[adgroup])
                addict[adgroup].append(hline)
        for i in range(59, 64): #Description
            hline = row[i]
            # print(i, hline)
            if len(hline) > 0:
                d[adgroup].append(hline)
    # print(addict)
fw = codecs.open('/Users/zooeytsai/Documents/有夠讚地標廣告datastudio.csv', 'w', 'utf-8')
fw.write("群組,廣告標題,廣告內容")


for k,v in addict.items():
    for i in range(len(v)):
        try:
            ad = addict[k][i]
            # print(ad)
        except:
            ad = ' '
        try:
            ad1 = d[k][i]
            print(ad1)
        except:
            ad1 = ' '
        data = "\n" + k + "," + ad + "," + ad1
        fw.write(data)

fw.close()

#    for k,v in addict.items():
#        print('rectangle '+k+'_ad'+' {')
#        print('card '+k+'廣告'+' [')

#        for itm in v:
#            print(itm)
#        print(']')
#        print('}')


#        print(campaign+' -[#black]-> '+k+'_ad')


#    print(kwdict)
#    print(addict)


#    for row in spamreader:
#        ll=len(row)
#
#        for i in range(ll):
#            print(i)
#            print(row[i])
#        break

#
#    sys.exit()