Содержание
Table from PrettyTable to pdf
I created a table using PrettyTable. I would like to save the output as a .pdf file but the only thing I can do is save it as .txt. How to save it as .pdf file? I installed the FPDF library but I am stucked with this.
# my table is saved as 'data' variable name # I saved the table ('data') as .txt file data = x.get_string() with open('nameoffile.txt', 'w') as f: f.write(data) print(data) 1 Answer 1
PrettyTable is not used to export data to pdf file. It’s used to display ASCII table.
The following code is a homemade method that answers your problem.
Lets assume you have this prettytable you want to export:
from prettytable import PrettyTable x = PrettyTable() x.field_names = ["City name", "Area", "Population", "Annual Rainfall"] x.add_row(["Adelaide", 1295, 1158259, 600.5]) x.add_row(["Brisbane", 5905, 1857594, 1146.4]) x.add_row(["Darwin", 112, 120900, 1714.7]) x.add_row(["Hobart", 1357, 205556, 619.5]) x.add_row(["Sydney", 2058, 4336374, 1214.8]) x.add_row(["Melbourne", 1566, 3806092, 646.9]) x.add_row(["Perth", 5386, 1554769, 869.4]) - First, you need to get the content of your table. The module isn’t supposed to work in this way : it assumes that you have a table content that you want to display. Let’s do the opposite :
def get_data_from_prettytable(data): """ Get a list of list from pretty_data table Arguments: :param data: data table to process :type data: PrettyTable """ def remove_space(liste): """ Remove space for each word in a list Arguments: :param liste: list of strings """ list_without_space = [] for mot in liste: # For each word in list word_without_space = mot.replace(' ', '') # word without space list_without_space.append(word_without_space) # list of word without space return list_without_space # Get each row of the table string_x = str(x).split('\n') # Get a list of row header = string_x[1].split('|')[1: -1] # Columns names rows = string_x[3:len(string_x) - 1] # List of rows list_word_per_row = [] for row in rows: # For each word in a row row_resize = row.split('|')[1:-1] # Remove first and last arguments list_word_per_row.append(remove_space(row_resize)) # Remove spaces return header, list_word_per_row from fpdf import FPDF def export_to_pdf(header, data): """ Create a a table in PDF file from a list of row :param header: columns name :param data: List of row (a row = a list of cells) :param spacing=1: """ pdf = FPDF() # New pdf object pdf.set_font("Arial", size=12) # Font style epw = pdf.w - 2*pdf.l_margin # Witdh of document col_width = pdf.w / 4.5 # Column width in table row_height = pdf.font_size * 1.5 # Row height in table spacing = 1.3 # Space in each cell pdf.add_page() # add new page pdf.cell(epw, 0.0, 'My title', align='C') # create title cell pdf.ln(row_height*spacing) # Define title line style # Add header for item in header: # for each column pdf.cell(col_width, row_height*spacing, # Add a new cell txt=item, border=1) pdf.ln(row_height*spacing) # New line after header for row in data: # For each row of the table for item in row: # For each cell in row pdf.cell(col_width, row_height*spacing, # Add cell txt=item, border=1) pdf.ln(row_height*spacing) # Add line at the end of row pdf.output('simple_demo.pdf') # Create pdf file pdf.close() # Close file Finally, you just have to call the two methods:
header, data = get_data_from_prettytable(x) export_to_pdf(header, data) Convert Python Pretty table to CSV using shell or batch command line
Thanks for looking into it but i think there should be an escape somewhere ? C:\test> nova list | grep -V ‘—-‘ | sed ‘s/^[^|]\+|//g’ | sed ‘s/|(.)/,\1/g’ | tr ‘|’ ‘\n’ grep: unrecognized option ‘—-‘ Usage: grep [OPTION]. PATTERN [FILE]. Try ‘grep —help’ for more information.
Here’s a real ugly one-liner
import csv s = """\ spu+--------------------------------------+--------+--------+------------+-------------+-----------------------------------+ | ID | Name | Status | Task State | Power State | Networks | +--------------------------------------+--------+--------+------------+-------------+-----------------------------------+ | 6bca09f8-a320-44d4-a11f-647dcec0aaa1 | tester | ACTIVE | - | Running | OpenStack-net=10.0.0.1, 10.0.0.3 | +--------------------------------------+--------+--------+------------+-------------+-----------------------------------+""" result = [tuple(filter(None, map(str.strip, splitline))) for line in s.splitlines() for splitline in [line.split("|")] if len(splitline) > 1] with open('output.csv', 'wb') as outcsv: writer = csv.writer(outcsv) writer.writerows(result) I can unwrap it a bit to make it nicer:
splitlines = s.splitlines() splitdata = line.split("|") splitdata = filter(lambda line: len(line) > 1, data) # toss the lines that don't have any data in them -- pure separator lines header, *data = [[field.strip() for field in line if field.strip()] for line in splitdata] result = [header] + data # I'm really just separating these, then re-joining them, but sometimes having # the headers separately is an important thing! result = [] for line in s.splitlines(): splitdata = line.split("|") if len(splitdata) == 1: continue # skip lines with no separators linedata = [] for field in splitdata: field = field.strip() if field: linedata.append(field) result.append(linedata) Выгрузка в текстовый файл в виде таблицы?
Получается так: 
Надо так:
Средний 4 комментария
t.add_row(["Итого", '','',it]) f.write(str(t))t.add_row(["Итого", '','',it]) IndentationError: unexpected indent
Arkadjan, unexpected indent это где-то с отступами сбилось. Проверьте.
Для того, чтобы можно было разобраться более подробно, нужно сделать так, чтобы код можно было запустить. Т.е. вставить в него типовые данные, у меня же нет ваших файлов, из которых данные берутся…
Алан Гибизов,
24
Петров
15 6300
Иванов
24 5600
Сидоров
19 4350
Николаев
15 4800
Малышев
21 4350
Соколов
12 7800
from prettytable import PrettyTable def data_for_table(): with open ('w.txt', encoding='utf-8') as file: names, days, salaries, pays = [], [], [], [] total = 0 work_days, *employees = file.read().splitlines() work_days=int(work_days.strip()) for elem in employees: if elem.strip().isalpha(): name = f"" names.append(name) else: paid_days, salary = elem.strip().split() pay = float(salary)/work_days*int(paid_days) total += pay days_str = f"3>" salary_str = f"10.2f>" pay_str = f"10.2f>" days.append(days_str) salaries.append(salary_str) pays.append(pay_str) rows = list(zip(names, days, salaries, pays)) total_str = f"10.2f>" return rows, total_str def table_with_footer(field_names, table_rows, table_title='', footer_field_name='', footer_field_value=''): pt_table = PrettyTable(padding_width=0) pt_table.field_names = field_names pt_table.add_rows(table_rows) if table_title: pt_table.title = table_title # Здесь используем костыль (хак?), чтобы сделать подвал таблицы (с итогами) # table footer if footer_field_name and footer_field_value: bottom_line = pt_table.get_string().splitlines()[-1] width_field_name, width_field_value = [len(line) for line in bottom_line[1:-1].rsplit('+', 1)] footer_fields = [f'>', f'>'] footer_row = f'||' table_footer = (f'\n' f'') else: table_footer = '' # Table with title and footer table = (f"\n" f"") return table table_rows, total_value = data_for_table() t_title = 'Зарплатная ведомость' f_names = ["Фамилия", "Дни", "Оклад", "Зарплата"] t_rows = table_rows footer_f_name = "Итого" footer_f_value = total_valueТолько таблица PrettyTable:
print(table_with_footer(f_names, t_rows)) +------------------------------+---+----------+----------+ | Фамилия |Дни| Оклад | Зарплата | +------------------------------+---+----------+----------+ |Петров | 15| 6300.00| 3937.50| |Иванов | 24| 5600.00| 5600.00| |Сидоров | 19| 4350.00| 3443.75| |Николаев | 15| 4800.00| 3000.00| |Малышев | 21| 4350.00| 3806.25| |Соколов | 12| 7800.00| 3900.00| +------------------------------+---+----------+----------+Таблица с тайтлом и футером:
print(table_with_footer(f_names, t_rows, t_title, footer_f_name, footer_f_value)) +--------------------------------------------------------+ | Зарплатная ведомость | +------------------------------+---+----------+----------+ | Фамилия |Дни| Оклад | Зарплата | +------------------------------+---+----------+----------+ |Петров | 15| 6300.00| 3937.50| |Иванов | 24| 5600.00| 5600.00| |Сидоров | 19| 4350.00| 3443.75| |Николаев | 15| 4800.00| 3000.00| |Малышев | 21| 4350.00| 3806.25| |Соколов | 12| 7800.00| 3900.00| +------------------------------+---+----------+----------+ |Итого | 23687.50| +------------------------------+---+----------+----------+Таблица только с футером (то, что в вопросе):
print(table_with_footer(f_names, t_rows, footer_field_name=footer_f_name, footer_field_value=footer_f_value)) +------------------------------+---+----------+----------+ | Фамилия |Дни| Оклад | Зарплата | +------------------------------+---+----------+----------+ |Петров | 15| 6300.00| 3937.50| |Иванов | 24| 5600.00| 5600.00| |Сидоров | 19| 4350.00| 3443.75| |Николаев | 15| 4800.00| 3000.00| |Малышев | 21| 4350.00| 3806.25| |Соколов | 12| 7800.00| 3900.00| +------------------------------+---+----------+----------+ |Итого | 23687.50| +------------------------------+---+----------+----------+