dfvue

Contents

dfvue#

Calling routine of dfvue

The calling routine sets up the toplevel root window and gets an instance of the dfvMain class.

This module was written by Matthias Cuntz while at Institut National de Recherche pour l’Agriculture, l’Alimentation et l’Environnement (INRAE), Nancy, France.

copyright:

Copyright 2023- Matthias Cuntz - mc (at) macu (dot) de

license:

MIT License, see LICENSE for details.

The following functions are provided:

dfvue([df, csvfile, sep, index_col, ...])

The main function to start the data frame GUI.

History
  • Written Jul 2023 by Matthias Cuntz (mc (at) macu (dot) de) adapted ncvue.py

  • Use CustomTkinter, Jun 2024, Matthias Cuntz

  • Use mix of grid and pack layout manager, Jun 2024, Matthias Cuntz

  • Use CustomTkinter only if installed, Jun 2024, Matthias Cuntz

  • Allow multiple input files, Oct 2024, Matthias Cuntz

  • Import pyplot for Windows, Oct 2024, Matthias Cuntz

  • Back to pack layout manager for resizing, Nov 2024, Matthias Cuntz

  • Pass Pandas DataFrame directly to dfvue, Jan 2025, Matthias Cuntz

  • Bugfix for checking if csvfile was given, Jan 2025, Matthias Cuntz

  • Use own ncvue-blue theme for customtkinter, Jan 2025, Matthias Cuntz

  • Use dfvScreen for window sizes, Nov 2025, Matthias Cuntz

dfvue(df=None, csvfile='', sep='', index_col=None, skiprows=None, parse_dates=True, date_format=None, missing_value=None)[source]#

The main function to start the data frame GUI.

Parameters:
  • df (pandas.DataFrame, optional) – Pandas DataFrame will be used if no csvfile given

  • csvfile (str or list of str, optional) – Name(s) of csv file (default: ‘’).

  • sep (str, optional) – Delimiter to use.

  • index_col (str, optional) – Column(s) to use as index, either given as column index or string name.

  • skiprows (str, optional) – Line numbers to skip (0-indexed, must include comma, e.g. “1,” for skipping the second row) or number of lines to skip (int, without comma) at the start of the file.

  • parse_dates (str, optional) –

    boolean. If True -> try parsing the index.

    list of int or names. e.g. If 1, 2, 3 -> try parsing columns 1, 2, 3 each as a separate date column.

    list of lists. e.g. If [1, 3] -> combine columns 1 and 3 and parse as a single date column.

    dict, e.g. “foo” : [1, 3] -> parse columns 1, 3 as date and call result

  • date_format (str, optional) – Will parse dates according to this format. For example: “%%Y-%%m-%%d %%H:%%M%%S”. See https://docs.python.org/3/library/datetime.html#strftime-and-strptime-behavior

  • missing_value (str, optional) – Missing or undefined value set to NaN.