Das deutsche Python-Forum

Code: Alles auswählen

....
d = pd.read_excel('Tonträger-Liste.xlsx',sheet_name='Tabelle1',header=0,names=['Band','Titel','Erscheinungsjahr','Format','Herkunft','Limitierug','Bemerkung','Band-korrigiert'])
d_format = d['Format'].value_counts(normalize=False, sort=True)
....
Musik_gesamt_Ausgabe = ttk.Label(root, text=str(d_format.to_string(header=True)), justify="left", font=("Arial", 15),borderwidth=2, relief="solid")
Musik_gesamt_Ausgabe.grid(row=1, column=2, padx=(20, 10), pady=(2, 2), columnspan=3, sticky="e")
....
Album_Input = tk.StringVar(root, value=FoundBand.to_string(header=True,index=False,justify="left", na_rep="---",col_space=15))
Album_label= ttk.Label(root, text=str(Album_Input.get()), justify='left', font=("Arial", 15),borderwidth=2, relief="solid")
Album_label.grid(row=5, column=0, padx=(20, 10), pady=(2, 2), columnspan=3, sticky="ew")
....

Code: Alles auswählen

import tkinter as tk

CONTENT = [
    ("Format", ""),
    ("CD", "530"),
    ("Digi-CD", "314"),
    ("LP", "211"),
    ("EP", "43"),
    ("MC", "23"),
    ("CD-R", "3"),
]

def main():
    window = tk.Tk()
    totals = tk.Frame(window)
    for index, row in enumerate(CONTENT):
        tk.Label(totals, text=row[0], anchor=tk.W).grid(row=index, column=1, sticky=tk.EW)
        tk.Label(totals, text=row[1], anchor=tk.E).grid(row=index, column=2, sticky=tk.EW)
    totals.pack()
    window.mainloop()

if __name__ == "__main__":
    main()

Code: Alles auswählen

import tkinter as tk

CONTENT = [
    ("Format", ""),
    ("CD", "530"),
    ("Digi-CD", "314"),
    ("LP", "211"),
    ("EP", "43"),
    ("MC", "23"),
    ("CD-R", "3"),
]

def make_labels(content, master):
    for i, row in enumerate(content):
        for j, string in enumerate(row):
            tk.Label(
                master, text=string, anchor=tk.E if string.isdigit() else tk.W
            ).grid(row=i, column=j, sticky=tk.EW)
    master.pack()

def main():
    window = tk.Tk()
    totals = tk.Frame(window)
    make_labels(CONTENT, totals)
    window.mainloop()

if __name__ == "__main__":
    main()

Code: Alles auswählen

def is_number(string):
    try:
        float(string)
    except ValueError:
        return False
    else:
        return True

Code: Alles auswählen

import tkinter as tk

CONTENT = [
    ["Format"],
    ["CD", "530", "spam"],
    ["Digi-CD", "314", "ham"],
    ["LP", "211", "eggs"],
    ["EP", "43", "foo"],
    ["MC", "23", "bar"],
    ["CD-R", "3", "baz"],
]

def make_frame(master, rows):
    frame = tk.Frame(master)
    for i, row in enumerate(rows):
        for j, string in enumerate(row):
            tk.Label(
                frame, text=string, anchor=tk.E if string.isdigit() else tk.W
            ).grid(row=i, column=j, padx=5, sticky=tk.EW)
    return frame

def main():
    window = tk.Tk()
    make_frame(window, CONTENT).pack(side=tk.LEFT)
    window.mainloop()

if __name__ == "__main__":
    main()

Code: Alles auswählen

import tkinter as tk
import pandas as pd

CONTENT = pd.DataFrame([
    ["Format"],
    ["CD", "530", "spam"],
    ["Digi-CD", "314", "ham"],
    ["LP", "211", "eggs"],
    ["EP", "43", "foo"],
    ["MC", "23", "bar"],
    ["CD-R", "3", "baz"],
])

def make_frame(master, rows):
    frame = tk.Frame(master)
    for i, row in enumerate(rows):
        for j, string in enumerate(row):
            anchor = "e" if string and string.isdigit() else "w"
            tk.Label(
                frame, text=string, anchor=anchor
            ).grid(row=i, column=j, padx=5, sticky="ew")
    return frame

def make_window(rows):
    window = tk.Tk()
    make_frame(window, rows).pack(expand=True)
    window.mainloop()

def main():
    make_window(CONTENT.values)

if __name__ == "__main__":
    main()

Code: Alles auswählen

import tkinter as tk
import pandas as pd

CONTENT = pd.DataFrame([
    ["CD", "530", "spam"],
    ["Digi-CD", "314", "ham"],
    ["LP", "211", "eggs"],
    ["EP", "43", "foo"],
    ["MC", "23", "bar"],
    ["CD-R", "3", "baz"],
])

def make_tabframe(master, rows):
    tabframe = tk.Text(master, font=('arial', 12, 'italic'), border=0, wrap='word', bg="#eaecac", tabs=('3c', tk.RIGHT, '5c', tk.RIGHT))
    tabframe.config(fg="#000000", height=10 ,  width=99,  padx=5, pady=0)
    content = 'Format\n'
    for row in rows:
        line = None
        for string in row:
            if line is None:
                line = string
            else:
                line = f'{line}\t{string}'
        content = f'{content}\n{line}'
    tabframe.insert('0.0', f'{content}')
    return tabframe

def make_window(rows):
    window = tk.Tk()
    make_tabframe(window, rows).pack(expand=True)
    window.mainloop()

def main():
    make_window(CONTENT.values)

if __name__ == "__main__":
    main()

Code: Alles auswählen

def make_tabframe(master, rows):
    tabframe = tk.Text(master,
        font=('arial', 12, 'italic'), 
        border=0,
        wrap='word',
        bg="#eaecac",
        tabs=('3c', tk.RIGHT, '5c', tk.RIGHT),
        fg="#000000",
        height=10,
        width=99,
        padx=5,
        pady=0
    )
    content = '\n'.join("\t".join(row) for row in rows)
    tabframe.insert('0.0', f'Format\n{content}')
    return tabframe