1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
import os
import glob
import pandas as pd
import csv
os.chdir("/Users/paul/Downloads")
extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]
#combine all files in the list
combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames ])
#export to csv
combined_csv.to_csv("combined_csv.csv", index=False, encoding='utf-8-sig')
with open('combined_csv.csv', encoding='utf8') as csv_file:
tracking_numb = csv.DictReader(csv_file)
print(tracking_numb)
for tracking_numb in tracking_numb:
print(tracking_numb['\ufeff\ufeffWaybill Number'], tracking_numb['Shipment Date'],tracking_numb['Recipient Country'], tracking_numb['Delivery Option'])
import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
creds = ServiceAccountCredentials.from_json_keyfile_name("/Users/paul/PycharmProjects/pythonProject2/creds.json", scope)
client = gspread.authorize(creds)
sheet = client.open("Python").sheet1
data = sheet.get_all_records()
insertRow = [tracking_numb['\ufeff\ufeffWaybill Number'], tracking_numb['Shipment Date'],tracking_numb['Recipient Country'], tracking_numb['Delivery Option']]
sheet.insert_row(insertRow, 2) |
Partager