前端之家

  1. 首页
  2. 问答

将Excel转换为CSV的Python代码-条件在PYCHARM中有效，但在Shell python中由于无效语法而失败

• 问答

我有几个Excel工作表，这些工作表将转换为csv，但遇到语法无效的错误。我试图仅获取行数大于3的内容。 这是我的代码

def convert_to_csv(excel_file,input_dir,output_dir):
    """Convert an excel file to a CSV file by removing irrelevant data"""
    try:
        sheet = read_excel(excel_file)
    except UnicodeDecodeError:
        print 'File %s is possibly corrupt. Please check again.' % (excel_file)
        sys.exit(1)
    row_num = sheet.get_highest_row()  # Number of rows
    col_num = sheet.get_highest_column()  # Number of columns
    all_rows = []
    # Loop through rows and columns
    for row in range(row_num):
        row_values = []
        for column in range(col_num):
            # Get cell element
            cell = sheet.cell(row=row,column=column)
            # Ignore empty cells
            if cell.value is not None:
                if type(cell.value) == int or type(cell.value) == float:
                    # String encoding not applicable for integers and floating point numbers
                    row_values.append(cell.value)
                else:
                    # Encode strings into ISO-8859-1 format to preserve content of cell
                    row_values.append(cell.value.encode("iso-8859-1").strip())
            else:
                row_values.append('')
        # Append rows only having more than three values each
        if len(set(row_values)-{''}) > 3:
            # print row_values
            all_rows.append(row_values)
    # Saving the data to a csv extension with the same name as the given excel file
    output_path = os.path.join(output_dir,excel_file.split('.')[0] + '.csv')
    with open(output_path,'wb') as f:
        writer = csv.writer(f)
        writer.writerows(all_rows[1:])
    print 'File %s saved to %s ' % (excel_file,output_path)

am循环浏览多个excel表，在一个特定的表中，我想删除的尾部有一些不需要的数据。

遇到此错误

19/11/12 03:13:33 WARN SparkConf: The configuration key 'spark.yarn.applicationmaster.waitTries' has been deprecated as of Spark 1.3 and and may be removed in the future. Please use the new key 'spark.yarn.am.waitTime' instead.
  File "/u/kim/excel_to_csv.py",line 49
    if len(set(row_values)-{''}) > 3:
                              ^
SyntaxError: invalid syntax

这在Pycharm上有效，但在Terminal上失败，我是否试图获取该行中的内容大于3的所有行，是否可以解决？

cywmm 回答：将Excel转换为CSV的Python代码-条件在PYCHARM中有效，但在Shell python中由于无效语法而失败

尝试更改此行：

if len(set(row_values)-{''}) > 3:

对此：

len(set(row_values)-set([''])) > 3:

我不知道为什么它在终端上失败。检查您的python版本。当我从python 2.7和3.6.8调用时，上面的语法有效：

 python test.py
, 
import openpyxl
from docx import Document
from docx.shared import Pt
from docx.enum.style import WD_STYLE
print "lists".decode("utf-8")
a=raw_input()
cid=[]
cid.append(0)
for i in a.split(' '):
    i=int(i)
    if not i in cid:
        cid.append(i)
cid.sort()
print cid
document = Document()
document.add_paragraph("Рўйхат".decode("utf-8")).size = Pt(14)
style = document.styles['Normal']
font = style.font
font.name = 'Times New Roman'
font.size = Pt(12)
qator=len(cid)
table = document.add_table(qator,6)
sheet = openpyxl.load_workbook('РЎЙХАТ.xlsx'.decode("utf-8")).active
pp=0
for x,i in enumerate(cid):
    print(i)
    r0 = sheet.cell(row=i+1,column=2).value
    r1 = sheet.cell(row=i+1,column=3).value
    r2 = sheet.cell(row=i+1,column=4).value
    r3 = sheet.cell(row=i+1,column=5).value
    r4 = sheet.cell(row=i+1,column=6).value
    heading_cells = table.rows[pp].cells
    heading_cells[0].text = str(x)
    heading_cells[1].text = r0
    heading_cells[2].text = r1
    heading_cells[3].text = r2
    heading_cells[4].text = r3
    heading_cells[5].text = r4
    pp=pp+1
document.save('РЎЙХАТ.docx'.decode("utf-8"))

# A special list compilation developed by @apiuz
# Writes data from Excel to word
# All businesses and organizations are free to use``

#xlsx to docx
apache-sparkcsvexcel
本文链接：https://www.f2er.com/3118869.html

大家都在问