isogeotoxlsx.utils.stats module¶
Statistics Calculator. Perform statistics analisis.
Author: Isogeo
Python: 3.7.x Created: 14/08/2014
-
class
isogeotoxlsx.utils.stats.
Stats
(lang='fr')¶ Bases:
object
Perform statistics calculations and make Excel charts.
-
attributes
(ws_attributes, all_attributes)¶ Perform feature attributes analisis and write results into the wanted worksheet.
- Parameters
ws_attributes (Worksheet) – sheet of a Workbook to write analisis
all_attributes (list) – list of all feature attributes. It’s a list of dicts.
-
li_data_formats
= []¶
-
li_dates_md_created
= []¶
-
li_dates_md_modified
= []¶
-
line_dates
(ws, li_dates_md_created=None, li_dates_md_modified=None, cell_start_table='O1', cell_start_chart='S1')¶ Calculates metadata creation and modification dates repartition and add a Line chart to the wanted sheet of Workbook.
- Parameters
ws (Worksheet) – sheet of a Workbook to write analisis
li_dates_md_created (list) – list of metadatas’creation dates. If not specified, the class attribute will be used instead.
li_dates_md_modified (list) – list of metadatas’modification dates. If not specified, the class attribute will be used instead.
cell_start_table (str) – cell of the sheet where to start writing table
cell_start_chart (str) – cell of the sheet where to start writing the chart
-
md_empty_fields
= {}¶
-
md_types_repartition
= {}¶
-
pie_formats
(ws, li_formats=None, cell_start_table='A20', cell_start_chart='D20')¶ Calculates metadata formats repartition and add a Pie chart to the wanted sheet of Workbook.
- Parameters
ws (Worksheet) – sheet of a Workbook to write analisis
li_formats (list) – list of all formats labels. If not specified, the class attribute will be used instaed
cell_start_table (str) – cell of the sheet where to start writing table
cell_start_chart (str) – cell of the sheet where to start writing the chart
-
pie_types
(ws, types_counters=None, cell_start_table='A1', cell_start_chart='D1')¶ Calculates metadata types repartition and add a Pie chart to the wanted sheet of Workbook.
- Parameters
ws (Worksheet) – sheet of a Workbook to write analisis
types_counters (dict) – dictionary of types/count. If not specified, the class attribute will be used instaed
cell_start_table (str) – cell of the sheet where to start writing table
cell_start_chart (str) – cell of the sheet where to start writing the chart
-