hi9tdZddlmZddlZddlmZddlmZddlm Z m Z m Z ddl m Z ddlmZGd d eZGd d eZGd deZGddeZGddeZGddeZGddeZGddeZGddeZGddeZGddeZGdd eZGd!d"eZGd#d$eZGd%d&eZdS)'zChartData and related objects.) annotationsN)Sequence)Number)BubbleWorkbookWriterCategoryWorkbookWriterXyWorkbookWriter)ChartXmlWriter) lazypropertyceZdZdZdfd ZdZdZdZdZe dZ d Z d Z d Z e d Zd ZdZe dZdZxZS)_BaseChartDataaBase class providing common members for chart data objects. A chart data object serves as a proxy for the chart data table that will be written to an Excel worksheet; operating as a sequence of series as well as providing access to chart-level attributes. A chart data object is used as a parameter in :meth:`shapes.add_chart` and :meth:`Chart.replace_data`. The data structure varies between major chart categories such as category charts and XY charts. Generalcrtt|||_g|_dSN)superr __init___number_format_series)self number_format __class__s g/var/www/development/aibuddy-work/election-extract/venv/lib/python3.11/site-packages/pptx/chart/data.pyrz_BaseChartData.__init__s2 nd##,,...+ c6|j|Sr)r __getitem__rindexs rrz_BaseChartData.__getitem__!s|''...rc4|jSr)r__len__rs rrz_BaseChartData.__len__$s|##%%%rc6|j|Sr)rappendrseriess rr!z_BaseChartData.append's|""6***rcbd}|D]}||ur|cS|t|z }td)z The total integer number of data points appearing in the series of this chart that are prior to *series* in this sequence. rseries not in chart data object)len ValueError)rr#count this_seriess rdata_point_offsetz _BaseChartData.data_point_offset*sO  & &K$$ S%% %EE:;;;rc|jS)ao The formatting template string, e.g. '#,##0.0', that determines how X and Y values are formatted in this chart and in the Excel spreadsheet. A number format specified on a series will override this value for that series. Likewise, a distinct number format can be specified for a particular data point within a series. rrs rrz_BaseChartData.number_format6s ""rcZt|D] \}}||ur|cStd)zH Return the integer index of *series* in this sequence. r%) enumerater')rr#idxss r series_indexz_BaseChartData.series_indexAsC oo  FC{{ :;;;rc6|j|S)zl Return the Excel worksheet reference to the cell containing the name for *series*. )_workbook_writerseries_name_refr"s rr4z_BaseChartData.series_name_refJs $44V<<||_||_||_g|_dSr) _chart_data_namer _data_points)r chart_datanamers rrz_BaseSeriesData.__init__s'% +rc6|j|Sr)rSrrs rrz_BaseSeriesData.__getitem__s ,,U333rc4|jSr)rSrrs rrz_BaseSeriesData.__len__s ((***rc6|j|Sr)rSr!)r data_points rr!z_BaseSeriesData.appends '' 333rc6|j|S)zm The integer count of data points that appear in all chart series prior to this one. )rQr*rs rr*z!_BaseSeriesData.data_point_offsets 11$777rc6|j|S)z Zero-based integer indicating the sequence position of this series in its chart. For example, the second of three series would return `1`. )rQr1rs rrz_BaseSeriesData.index ,,T222rc"|j|jndS)z The name of this series, e.g. 'Series 1'. This name is used as the column heading for the y-values of this series and may also appear in the chart legend and perhaps other chart locations. N)rRrs rrUz_BaseSeriesData.names"Z3tzz;rc6|j|S)zh The Excel worksheet reference to the cell containing the name for this series. )rQr4rs rname_refz_BaseSeriesData.name_refs //555rc0|j}| |jjS|S)a The formatting template string that determines how a number in this series is formatted, both in the chart and in the Excel spreadsheet; for example '#,##0.0'. If not specified for this series, it is inherited from the parent chart data object. )rrQrrrs rrz_BaseSeriesData.number_formats$+  #1 1rc$d|jDS)zr A sequence containing the X value of each datapoint in this series, in data point order. cg|] }|j S)x.0dps r z,_BaseSeriesData.x_values..111111rrSrs rx_valuesz_BaseSeriesData.x_values 21t01111rc6|j|S)zz The Excel worksheet reference to the X values for this chart (not including the column heading). )rQr6rs rr6z_BaseSeriesData.x_values_refr\rc$d|jDS)zr A sequence containing the Y value of each datapoint in this series, in data point order. cg|] }|j Sre)yrgs rrjz,_BaseSeriesData.y_values..rkrrlrs ry_valuesz_BaseSeriesData.y_valuesrnrc6|j|S)zz The Excel worksheet reference to the Y values for this chart (not including the column heading). )rQrArs rrAz_BaseSeriesData.y_values_refr\rN)rGrHrIrJrrrr!rKr*rrUr`rrmr6rsrArerrrOrOsM 444+++44488X833X3<<X<66X6  X 22X233X322X233X333rrOc8eZdZdZfdZedZxZS)_BaseDataPointzE Base class providing common members for data point objects. crtt|||_||_dSr)rrvr _series_datar)r series_datarrs rrz_BaseDataPoint.__init__s5 nd##,,...'+rc0|j}| |jjS|S)a( The formatting template string that determines how the value of this data point is formatted, both in the chart and in the Excel spreadsheet; for example '#,##0.0'. If not specified for this data point, it is inherited from the parent series data object. )rrxrrbs rrz_BaseDataPoint.number_formats$+  $2 2r)rGrHrIrJrrKrrLrMs@rrvrvs],,,,,   X     rrvceZdZdZdZd dZedZejdZedZ d Z e d Z dS) CategoryChartDataa Accumulates data specifying the categories and series values for a chart and acts as a proxy for the chart data table that will be written to an Excel worksheet. Used as a parameter in :meth:`shapes.add_chart` and :meth:`Chart.replace_data`. This object is suitable for use with category charts, i.e. all those having a discrete set of label values (categories) as the range of their independent variable (X-axis) values. Unlike the ChartData types for charts supporting a continuous range of independent variable values (such as XyChartData), CategoryChartData has a single collection of category (X) values and each data point in its series specifies only the Y value. The corresponding X value is inferred by its position in the sequence. c6|j|S)a Return a newly created |data.Category| object having *label* and appended to the end of the category collection for this chart. *label* can be a string, a number, a datetime.date, or datetime.datetime object. All category labels in a chart must be the same type. All category labels in a chart having multi-level categories must be strings. ) categories add_category)rlabels rrzCategoryChartData.add_categorys++E222rreNct|||}|||D]}|||S)a> Add a series to this data set entitled *name* and having the data points specified by *values*, an iterable of numeric values. *number_format* specifies how the series values will be displayed, and may be a string, e.g. '#,##0' corresponding to an Excel number format. )CategorySeriesDatar!add_data_point)rrUvaluesrryvalues r add_serieszCategoryChartData.add_seriessS)t]CC  K    . .E  & &u - - - -rcXt|ddst|_|jS)a|data.Categories| object providing access to category-object hierarchy. Assigning an iterable of category labels (strings, numbers, or dates) replaces the |data.Categories| object with a new one containing a category for each label in the sequence. Creating a chart from chart data having date categories will cause the chart to have a |DateAxis| for its category axis. _categoriesF)getattr Categoriesrrs rr~zCategoryChartData.categories(s-t]E22 ,)||D rcdt}|D]}||||_dSr)rrr)rcategory_labelsr~rs rr~zCategoryChartData.categories7s?\\ $ + +E  # #E * * * *%rc|jjSz| The Excel worksheet reference to the categories for this chart (not including the column heading). )r3categories_refrs rrz CategoryChartData.categories_ref>s $33rc6|j|S)zv The Excel worksheet reference to the values for *series* (not including the column heading). )r3 values_refr"s rrzCategoryChartData.values_refFs $//777rc t|SrC)rrs rr3z"CategoryChartData._workbook_writerMs &d+++r)reN) rGrHrIrJrrrKr~setterrrr r3rerrr|r|s   3 3 3       X  &&& 44X4888,,\,,,rr|ceZdZdZfdZdZdZdZedZ edZ edZ d Z ed Z ed Zed Zejd ZxZS)rz A sequence of |data.Category| objects, also having certain hierarchical graph behaviors for support of multi-level (nested) categories. crtt|g|_d|_dSr)rrrrr)rrs rrzCategories.__init__\s5 j$((***"rc6|j|Sr)rr)rr/s rrzCategories.__getitem__as++C000rc4|jS)z Return the count of the highest level of category in this sequence. If it contains hierarchical (multi-level) categories, this number will differ from :attr:`category_count`, which is the number of leaf nodes. )rrrs rrzCategories.__len__ds'')))rcZt||}|j||S)a Return a newly created |data.Category| object having *label* and appended to the end of this category sequence. *label* can be a string, a number, a datetime.date, or datetime.datetime object. All category labels in a chart must be the same type. All category labels in a chart having multi-level categories must be strings. Creating a chart from chart data having date categories will cause the chart to have a |DateAxis| for its category axis. )Categoryrr!rrcategorys rrzCategories.add_categoryms/E4(( )))rc|jdkrdS|dj}tjtjf}t ||rdSdS)a Return |True| if the first category in this collection has a date label (as opposed to str or numeric). A date label is one of type datetime.date or datetime.datetime. Returns |False| otherwise, including when this category collection is empty. It also returns False when this category collection is hierarchical, because hierarchical categories can only be written as string labels. FrT)depthrdatetimedate isinstance)rfirst_cat_label date_typess r are_dateszCategories.are_dates|sJ :??5q'-mX%67 oz 2 2 4urc|jdkrdS|dj}ttjtjf}t ||rdSdS)a Return |True| if the first category in this collection has a numeric label (as opposed to a string label), including if that value is a datetime.date or datetime.datetime object (as those are converted to integers for storage in Excel). Returns |False| otherwise, including when this category collection is empty. It also returns False when this category collection is hierarchical, because hierarchical categories can only be written as string labels. rFrT)rrrrrr)rr numeric_typess r are_numericzCategories.are_numericsN :??5 q'-0AB o} 5 5 4urc|j}|sdS|dj}|ddD]}|j|krtd|S)zx The number of hierarchy levels in this category graph. Returns 0 if it contains no categories. rrNcategory depth not uniform)rrr')rr~ first_depthrs rrzCategories.depthsc %  1 m) "122 ? ?H~,, !=>>>-rc\d}|jD]}||ur|cS||jz }td)z The offset of *category* in the overall sequence of leaf categories. A non-leaf category gets the index of its first sub-category. rz$category not in top-level categories)r leaf_countr')rrr this_categorys rrzCategories.indexsM !- . .M=(( ]- -EE?@@@rc>td|jDS)z The number of leaf-level categories in this hierarchy. The return value is the same as that of `len()` only when the hierarchy is single level. c3$K|] }|jV dSrr)rhcs r z(Categories.leaf_count..s$::A1<::::::r)sumrrs rrzCategories.leaf_counts$::)9::::::rc#:Kfd|D]}|VdS)z A generator of (idx, label) sequences representing the category hierarchy from the bottom up. The first level contains all leaf categories, and each subsequent is the next level up. c3hKd|D}|r|D]}|Vd|DVdS)Nc&g|]}|jD]}|Sre)sub_categories)rhrscs rrjz5Categories.levels..levels..s(PPPQq?OPPbPPPPrc*g|]}|j|jfSre)r/r)rhcats rrjz5Categories.levels..levels..s!>>>CCGSY'>>>rre)r~rlevellevelss rrz!Categories.levels..levelssfPP*PPPN #VN33  EKKKK>>:>>> > > > > >rNre)rrrs @rrzCategories.levelssN ? ? ? ? ?VD\\  EKKKK  rcd}|j|jS|jdkr|S|dj}t|tjtjfrdS|S)a Read/write. Return a string representing the number format used in Excel to format these category values, e.g. '0.0' or 'mm/dd/yyyy'. This string is only relevant when the categories are numeric or date type, although it returns 'General' without error when the categories are string labels. Assigning |None| causes the default number format to be used, based on the type of the category labels. r Nrrz yyyy\-mm\-dd)rrrrrr)rGENERALrs rrzCategories.number_formatsb   *& & :??Nq'- o x7H'I J J #"?rc||_dSrr,)rrs rrzCategories.number_formats#r)rGrHrIrJrrrrrKrrrrrrrrrLrMs@rrrVsB ##### 111***   X"X,  X  A A A;;X;X&X4$$$$$$$rrceZdZdZfdZdZedZedZdZ edZ edZ d d Z ed Z d ZxZS)rz A chart category, primarily having a label to be displayed on the category axis, but also able to be configured in a hierarchy for support of multi-level category charts. ctt|||_||_g|_dSr)rrr_label_parent_sub_categories)rrparentrs rrzCategory.__init__s; h&&(((  !rcZt||}|j||S)z Return a newly created |data.Category| object having *label* and appended to the end of the sub-category sequence for this category. )rrr!rs radd_sub_categoryzCategory.add_sub_category s/ E4(( ##H---rc|j}|sdS|dj}|ddD]}|j|krtd|dzS)z The number of hierarchy levels rooted at this category node. Returns 1 if this category has no sub-categories. rrNr)rrr')rrrrs rrzCategory.depthsi - 1$Q'- &qrr* ? ?H~,, !=>>>-Qrc6|j|S)z The offset of this category in the overall sequence of leaf categories. A non-leaf category gets the index of its first sub-category. )rrrs rr/z Category.idx"s|!!$'''rc|j|}|jD]}||ur|cS||jz }t d)zb The offset of *sub_category* in the overall sequence of leaf categories. z!sub_category not in this category)rrrrr')r sub_categoryrthis_sub_categorys rrzCategory.index+s`  ""4((!%!5 2 2 000 &1 1EE<===rcP|jsdStd|jDS)z The number of leaf category nodes under this category. Returns 1 if this category has no sub-categories. rc3$K|] }|jV dSrr)rhrs rrz&Category.leaf_count..?s%LL88&LLLLLLr)rrrs rrzCategory.leaf_count7s4 # 1LLt7KLLLLLLrc"|j|jndS)z The value that appears on the axis for this category. The label can be a string, a number, or a datetime.date or datetime.datetime object. Nr^)rrs rrzCategory.labelAs#k5t{{2=rFc|j}t|tjtjfrd||zSt |jS)a The string representation of the numeric (or date) label of this category, suitable for use in the XML `c:pt` element for this category. The optional *date_1904* parameter specifies the epoch used for calculating Excel date numbers. z%.1f)rrrr_excel_date_numberstr)r date_1904rs rnumeric_str_valzCategory.numeric_str_valJsP  ehmX->? @ @ ?D33I>>> >4;rc|jS)zE The sequence of child categories for this category. )rrs rrzCategory.sub_categoriesVs ##rctj|j}}||j|j|j}|r |dddn |ddd}||z }|j}|s |dkr|dz }|S)z Return an integer representing the date label of this category as the number of days since January 1, 1900 (or 1904 if date_1904 is |True|). iprik ;)rrryearmonthdaydays)rrrrdate_epochdeltaexcel_day_numbers rrzCategory._excel_date_number]s mT[eUZei88$-ET1a   44b"3E3E  : "-22  ! r)F)rGrHrIrJrrrKrr/rrrrrrrLrMs@rrrs  """""   X ((X( > > >MMXM>>X>     $$X$        rrceZdZdZdS) ChartDataz |ChartData| is simply an alias for |CategoryChartData| and may be removed in a future release. All new development should use |CategoryChartData| for creating or replacing the data in chart types other than XY and Bubble. N)rGrHrIrJrerrrrqsrrcreZdZdZddZedZedZedZedZ dS) rz The data specific to a particular category chart series. It provides access to the series label, the series data points, and an optional number format to be applied to each data point not having a specified number format. NcRt|||}|||S)z Return a CategoryDataPoint object newly created with value *value*, an optional *number_format*, and appended to this sequence. )CategoryDataPointr!)rrrrYs rrz!CategorySeriesData.add_data_points- 'tUMBB  Jrc|jjS)zt The |data.Categories| object that provides access to the category objects for this series. )rQr~rs rr~zCategorySeriesData.categoriess **rc|jjSr)rQrrs rrz!CategorySeriesData.categories_refs ..rc$d|jDS)zt A sequence containing the (Y) value of each datapoint in this series, in data point order. cg|] }|j Sre)rrgs rrjz-CategorySeriesData.values..s555R555rrlrs rrzCategorySeriesData.valuess 654#45555rc6|j|S)z} The Excel worksheet reference to the (Y) values for this series (not including the column heading). )rQrrs rrzCategorySeriesData.values_refs **4000rr) rGrHrIrJrrKr~rrrrerrrrzs++X+//X/66X611X111rrc0eZdZdZddZedZdS) XyChartDataz A specialized ChartData object suitable for use with an XY (aka. scatter) chart. Unlike ChartData, it has no category sequence. Rather, each data point of each series specifies both an X and a Y value. NcRt|||}|||S)z Return an |XySeriesData| object newly created and added at the end of this sequence, identified by *name* and values formatted with *number_format*. ) XySeriesDatar!rrUrrys rrzXyChartData.add_seriess- #4}==  K   rc t|Sr)rrs rr3zXyChartData._workbook_writers  %%%rr)rGrHrIrJrr r3rerrrrsM &&\&&&rrc6eZdZdZddZdZedZdS)BubbleChartDataz A specialized ChartData object suitable for use with a bubble chart. A bubble chart is essentially an XY chart where the markers are scaled to provide a third quantitative dimension to the exhibit. NcRt|||}|||S)z Return a |BubbleSeriesData| object newly created and added at the end of this sequence, and having series named *name* and values formatted with *number_format*. )BubbleSeriesDatar!rs rrzBubbleChartData.add_seriess- 'tT=AA  K   rc6|j|S)zo The Excel worksheet reference for the range containing the bubble sizes for *series*. )r3bubble_sizes_refr"s rrz BubbleChartData.bubble_sizes_refs $55f===rc t|Sr)rrs rr3z BubbleChartData._workbook_writers $D)))rr)rGrHrIrJrrr r3rerrrrs\ >>>**\***rrceZdZdZddZdS)ra The data specific to a particular XY chart series. It provides access to the series label, the series data points, and an optional number format to be applied to each data point not having a specified number format. The sequence of data points in an XY series is significant; lines are plotted following the sequence of points, even if that causes a line segment to "travel backward" (implying a multi-valued function). The data points are not automatically sorted into increasing order by X value. NcTt||||}|||S)z| Return an XyDataPoint object newly created with values *x* and *y*, and appended to this sequence. ) XyDataPointr!)rrfrrrrYs rrzXySeriesData.add_data_points/ !q!];;  Jrr)rGrHrIrJrrerrrrs2  rrcFeZdZdZddZedZedZdS)ra The data specific to a particular Bubble chart series. It provides access to the series label, the series data points, and an optional number format to be applied to each data point not having a specified number format. The sequence of data points in a bubble chart series is maintained throughout the chart building process because a data point has no unique identifier and can only be retrieved by index. NcVt|||||}|||S)z Append a new BubbleDataPoint object having the values *x*, *y*, and *size*. The optional *number_format* is used to format the Y value. If not provided, the number format is inherited from the series data. )BubbleDataPointr!)rrfrrsizerrYs rrzBubbleSeriesData.add_data_point s1 %T1a}EE  Jrc$d|jDS)zw A sequence containing the bubble size for each datapoint in this series, in data point order. cg|] }|j Sre) bubble_sizergs rrjz1BubbleSeriesData.bubble_sizes..s;;;2;;;rrlrs r bubble_sizeszBubbleSeriesData.bubble_sizess <;):;;;;rc6|j|S)zr The Excel worksheet reference for the range containing the bubble sizes for this series. )rQrrs rrz!BubbleSeriesData.bubble_sizes_refs 00666rr)rGrHrIrJrrKrrrerrrrsh  <<X<77X777rrc8eZdZdZfdZedZxZS)rz A data point in a category chart series. Provides access to the value of the datapoint and the number format with which it should appear in the Excel file. chtt|||||_dSr)rrr_value)rryrrrs rrzCategoryDataPoint.__init__+s/ &&// ]KKK rc|jS)z= The (Y) value for this category data point. )rrs rrzCategoryDataPoint.value/s {r)rGrHrIrJrrKrrLrMs@rrr$s] XrrcNeZdZdZfdZedZedZxZS)rzi A data point in an XY chart series. Provides access to the x and y values of the datapoint. cvtt|||||_||_dSr)rrr_x_y)rryrfrrrrs rrzXyDataPoint.__init__=s5 k4  ))+}EEErc|jS)z5 The X value for this XY data point. )r rs rrfz XyDataPoint.xB wrc|jS)z5 The Y value for this XY data point. )r rs rrrz XyDataPoint.yIrr) rGrHrIrJrrKrfrrrLrMs@rrr7sx  X Xrrc8eZdZdZfdZedZxZS)rzs A data point in a bubble chart series. Provides access to the x, y, and size values of the datapoint. cltt|||||||_dSr)rrr_size)rryrfrrrrrs rrzBubbleDataPoint.__init__Ws2 ot$$--k1aOOO rc|jS)zT The value representing the size of the bubble for this data point. )rrs rrzBubbleDataPoint.bubble_size[s zr)rGrHrIrJrrKrrLrMs@rrrQs] Xrr) rJ __future__rrcollections.abcrnumbersrpptx.chart.xlsxrrrpptx.chart.xmlwriterr pptx.utilr r rOobjectrvr|rrrrrrrrrrrrerrrsS$$""""""$$$$$$ 0/////""""""l4l4l4l4l4Xl4l4l4^c3c3c3c3c3hc3c3c3LV0T,T,T,T,T,T,T,T,nd$d$d$d$d$d$d$d$Nq q q q q vq q q h!/1/1/1/1/1/1/1/1d&&&&&.&&&4*****k***B?,$7$7$7$7$7|$7$7$7N&.4kr