python导入excel模块_Python利用Psycopg2模块将Excel表格数据导入Postgressql

import os

import numpy as np

import pandas as pd

import xlrd

import psycopg2

import redis

conn = redis.Redis(host=‘localhost‘, port=6379)

pipe = conn.pipeline()

def check_data():

book = xlrd.open_workbook(‘test.xlsx‘)

sheet = book.sheet_by_name("Sheet1")

conn = psycopg2.connect(dbname="ggg",

user=‘postgres‘,

password=‘521314‘,

host="localhost",

port=5432)

count = 0

cur = conn.cursor()

error_list = []

for r in range(1, sheet.nrows):

name = sheet.cell(r, 0).value

email = sheet.cell(r, 1).value

data = (re.match(r‘^[a-zA-Z0-9_-]+(\.[a-zA-Z0-9_-]+){0,4}@[a-zA-Z0-9_-]+(\.[a-zA-Z0-9_-]+){0,4}$‘, email)) and 1 or 0

if not (not data or name):

count += 1

error_dict = {&#