o j9t@sPdZddlmZddlZddlmZddlmZddlm Z m Z m Z ddl m Z ddlmZGd d d eZGd d d eZGd ddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdd d eZGd!d"d"eZGd#d$d$eZGd%d&d&eZdS)'zChartData and related objects.) annotationsN)Sequence)Number)BubbleWorkbookWriterCategoryWorkbookWriterXyWorkbookWriter)ChartXmlWriter) lazypropertycseZdZdZdfdd ZddZddZd d Zd d Ze d dZ ddZ ddZ ddZ e ddZddZddZe ddZddZZS) _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. Generalcstt|||_g|_dSN)superr __init___number_format_seriesself number_format __class__O/home/air/Certificate/back/venv/lib/python3.10/site-packages/pptx/chart/data.pyr z_BaseChartData.__init__cC |j|Sr )r __getitem__rindexrrrr! z_BaseChartData.__getitem__cC |jSr )r__len__rrrrr$ z_BaseChartData.__len__cCrr )rappendrseriesrrrr"'rz_BaseChartData.appendcCs2d}|D]}||ur|S|t|7}qtd)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_seriesrrrdata_point_offset*s z _BaseChartData.data_point_offsetcC|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. rr rrrr6s z_BaseChartData.number_formatcCs*t|D] \}}||ur|Sqtd)zH Return the integer index of *series* in this sequence. r%) enumerater')rr$idxsrrr series_indexAs z_BaseChartData.series_indexcCr)zl Return the Excel worksheet reference to the cell containing the name for *series*. )_workbook_writerseries_name_refr#rrrr2J z_BaseChartData.series_name_refcCr)zv The Excel worksheet reference to the X values for *series* (not including the column label). )r1 x_values_refr#rrrr4Qr3z_BaseChartData.x_values_refcC|jjS)z Return a blob containing an Excel workbook file populated with the contents of this chart data object. )r1 xlsx_blobr rrrr6Xz_BaseChartData.xlsx_blobcCs||dS)z Return a blob containing the XML for a chart of *chart_type* containing the series in this chart data object, as bytes suitable for writing directly to a file. zutf-8)_xmlencoder chart_typerrr xml_bytes`z_BaseChartData.xml_bytescCr)zv The Excel worksheet reference to the Y values for *series* (not including the column label). )r1 y_values_refr#rrrr>hr3z_BaseChartData.y_values_refcCstd) The worksheet writer object to which layout and writing of the Excel worksheet for this chart will be delegated. z%must be implemented by all subclasses)NotImplementedErrorr rrrr1or7z_BaseChartData._workbook_writercCs t||jS)z Return (as unicode text) the XML for a chart of *chart_type* populated with the values in this chart data object. The XML is a complete XML document, including an XML declaration specifying UTF-8 encoding. )rxmlr:rrrr8w z_BaseChartData._xml)r )__name__ __module__ __qualname____doc__rrrr"r*propertyrr0r2r4r6r<r>r1r8 __classcell__rrrrr s&      r c@seZdZdZddZddZddZdd Zed d Z ed d Z eddZ eddZ eddZ eddZeddZeddZeddZdS)_BaseSeriesDataa  Base class providing common members for series data objects. A series data object serves as proxy for a series data column in the Excel worksheet. It operates as a sequence of data points, as well as providing access to series-level attributes like the series label. cCs||_||_||_g|_dSr ) _chart_data_namer _data_points)r chart_datanamerrrrrs z_BaseSeriesData.__init__cCrr )rLrrrrrrrz_BaseSeriesData.__getitem__cCrr )rLrr rrrrr!z_BaseSeriesData.__len__cCrr )rLr")r data_pointrrrr"rz_BaseSeriesData.appendcC |j|S)zm The integer count of data points that appear in all chart series prior to this one. )rJr*r rrrr* z!_BaseSeriesData.data_point_offsetcCrP)z Zero-based integer indicating the sequence position of this series in its chart. For example, the second of three series would return `1`. )rJr0r rrrrrQz_BaseSeriesData.indexcC|jdur|jSdS)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)rKr rrrrNz_BaseSeriesData.namecCrP)zh The Excel worksheet reference to the cell containing the name for this series. )rJr2r rrrname_refrQz_BaseSeriesData.name_refcC|j}|dur |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. N)rrJrrrrrrz_BaseSeriesData.number_formatcCdd|jDS)zr A sequence containing the X value of each datapoint in this series, in data point order. cSg|]}|jqSr)x.0dprrr z,_BaseSeriesData.x_values..rLr rrrx_valuesr=z_BaseSeriesData.x_valuescCrP)zz The Excel worksheet reference to the X values for this chart (not including the column heading). )rJr4r rrrr4rQz_BaseSeriesData.x_values_refcCrX)zr A sequence containing the Y value of each datapoint in this series, in data point order. cSrYr)yr[rrrr^r_z,_BaseSeriesData.y_values..r`r rrry_valuesr=z_BaseSeriesData.y_valuescCrP)zz The Excel worksheet reference to the Y values for this chart (not including the column heading). )rJr>r rrrr>rQz_BaseSeriesData.y_values_refN)rCrDrErFrrrr"rGr*rrNrUrrar4rcr>rrrrrIs0        rIc,eZdZdZfddZeddZZS)_BaseDataPointzE Base class providing common members for data point objects. cstt|||_||_dSr )r rer _series_datar)r series_datarrrrrrz_BaseDataPoint.__init__cCrV)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. N)rrfrrrrrrrWz_BaseDataPoint.number_format)rCrDrErFrrGrrHrrrrres  rec@s\eZdZdZddZdddZedd Zejd d Zed d Z d dZ e ddZ 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. cCr)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)rlabelrrrrjs zCategoryChartData.add_categoryrNcCs.t|||}|||D]}||q |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)rrNvaluesrrgvaluerrr add_seriess   zCategoryChartData.add_seriescCst|dds t|_|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 Categoriesrqr rrrri(s zCategoryChartData.categoriescCs$t}|D]}||q||_dSr )rsrjrq)rcategory_labelsrirkrrrri7s  cCr5z| The Excel worksheet reference to the categories for this chart (not including the column heading). )r1categories_refr rrrrv>r7z CategoryChartData.categories_refcCr)zv The Excel worksheet reference to the values for *series* (not including the column heading). )r1 values_refr#rrrrwFr3zCategoryChartData.values_refcCt|Sr?)rr rrrr1Mr7z"CategoryChartData._workbook_writer)rN) rCrDrErFrjrprGrisetterrvrwr r1rrrrrhs    rhcseZdZdZfddZddZddZdd Zed d Z ed d Z eddZ ddZ eddZ eddZeddZejddZZS)rsz A sequence of |data.Category| objects, also having certain hierarchical graph behaviors for support of multi-level (nested) categories. cstt|g|_d|_dSr )r rsrrqrr rrrr\rzCategories.__init__cCrr )rqr)rr.rrrrarzCategories.__getitem__cCr)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. )rqrr rrrrds zCategories.__len__cCt||}|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. )Categoryrqr"rrkcategoryrrrrjms zCategories.add_categorycCs6|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)depthrkdatetimedate isinstance)rfirst_cat_label date_typesrrr are_dates|s    zCategories.are_datescCs8|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)rrkrrrr)rr numeric_typesrrr are_numerics   zCategories.are_numericcCs@|j}|sdS|dj}|ddD] }|j|krtdq|S)zx The number of hierarchy levels in this category graph. Returns 0 if it contains no categories. rrNcategory depth not uniform)rqrr')rri first_depthr~rrrrs  zCategories.depthcCs2d}|jD]}||ur|S||j7}qtd)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)rq leaf_countr')rr~r this_categoryrrrrs   zCategories.indexcCstdd|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. cs|]}|jVqdSr r)r\crrr z(Categories.leaf_count..)sumrqr rrrrrTzCategories.leaf_countc#s&fdd|D]}|Vq dS)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. c3s<dd|D}|r|D]}|Vqdd|DVdS)NcSsg|] }|jD]}|qqSr)sub_categories)r\rscrrrr^sz5Categories.levels..levels..cSsg|]}|j|jfqSr)r.rk)r\catrrrr^sr)rirlevellevelsrrrs  z!Categories.levels..levelsNr)rrrrrrs   zCategories.levelscCsFd}|jdur |jS|jdkr|S|dj}t|tjtjfr!dS|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)rrrkrrr)rGENERALrrrrrs   zCategories.number_formatcCs ||_dSr r,)rrorrrrs )rCrDrErFrrrrjrGrrrrrrrrzrHrrrrrsVs*        rscs~eZdZdZfddZddZeddZedd Zd d Z ed d Z eddZ dddZ eddZ ddZZS)r|z 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. cs$tt|||_||_g|_dSr )r r|r_label_parent_sub_categories)rrkparentrrrrs zCategory.__init__cCr{)z Return a newly created |data.Category| object having *label* and appended to the end of the sub-category sequence for this category. )r|rr"r}rrradd_sub_category s  zCategory.add_sub_categorycCsD|j}|sdS|dj}|ddD] }|j|krtdq|dS)z The number of hierarchy levels rooted at this category node. Returns 1 if this category has no sub-categories. rrNr)rrr')rrrr~rrrrs  zCategory.depthcCrP)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. )rrr rrrr."rBz Category.idxcCs:|j|}|jD]}||ur|S||j7}q td)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_categoryrrrr+s   zCategory.indexcCs|jsdStdd|jDS)z The number of leaf category nodes under this category. Returns 1 if this category has no sub-categories. rcsrr r)r\r~rrrr?rz&Category.leaf_count..)rrr rrrr7szCategory.leaf_countcCrR)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. NrS)rr rrrrkArTzCategory.labelFcCs0|j}t|tjtjfrd||St|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_1904rkrrrnumeric_str_valJs zCategory.numeric_str_valcCr+)zE The sequence of child categories for this category. )rr rrrrVzCategory.sub_categoriescCsbtj|j}}||j|j|j}|r|dddn|ddd}||}|j}|s/|dkr/|d7}|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)rrrrkdate_epochdeltaexcel_day_numberrrrr]s zCategory._excel_date_number)F)rCrDrErFrrrGrr.rrrkrrrrHrrrrr|s"       r|c@seZdZdZdS) 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)rCrDrErFrrrrrqsrc@sJeZdZdZd ddZeddZeddZed d Zed d Z dS)rlz 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. NcCt|||}|||S)z Return a CategoryDataPoint object newly created with value *value*, an optional *number_format*, and appended to this sequence. )CategoryDataPointr")rrorrOrrrrms  z!CategorySeriesData.add_data_pointcCr5)zt The |data.Categories| object that provides access to the category objects for this series. )rJrir rrrrir7zCategorySeriesData.categoriescCr5ru)rJrvr rrrrvr7z!CategorySeriesData.categories_refcCrX)zt A sequence containing the (Y) value of each datapoint in this series, in data point order. cSrYr)ror[rrrr^r_z-CategorySeriesData.values..r`r rrrrnr=zCategorySeriesData.valuescCrP)z} The Excel worksheet reference to the (Y) values for this series (not including the column heading). )rJrwr rrrrwrQzCategorySeriesData.values_refr ) rCrDrErFrmrGrirvrnrwrrrrrlzs    rlc@s&eZdZdZdddZeddZdS) 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. NcCr)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"rrNrrgrrrrp  zXyChartData.add_seriescCrxry)rr rrrr1r7zXyChartData._workbook_writerr )rCrDrErFrpr r1rrrrrs   rc@s.eZdZdZd ddZddZeddZdS) 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. NcCr)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"rrrrrprzBubbleChartData.add_seriescCr)zo The Excel worksheet reference for the range containing the bubble sizes for *series*. )r1bubble_sizes_refr#rrrrr3z BubbleChartData.bubble_sizes_refcCrxry)rr rrrr1r7z BubbleChartData._workbook_writerr )rCrDrErFrprr r1rrrrrs   rc@seZdZdZdddZdS)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. NcCst||||}|||S)z| Return an XyDataPoint object newly created with values *x* and *y*, and appended to this sequence. ) XyDataPointr")rrZrbrrOrrrrms zXySeriesData.add_data_pointr )rCrDrErFrmrrrrrs rc@s2eZdZdZd ddZeddZeddZdS) 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. NcCst|||||}|||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")rrZrbsizerrOrrrrm s zBubbleSeriesData.add_data_pointcCrX)zw A sequence containing the bubble size for each datapoint in this series, in data point order. cSrYr) bubble_sizer[rrrr^r_z1BubbleSeriesData.bubble_sizes..r`r rrr bubble_sizesr=zBubbleSeriesData.bubble_sizescCrP)zr The Excel worksheet reference for the range containing the bubble sizes for this series. )rJrr rrrrrQz!BubbleSeriesData.bubble_sizes_refr )rCrDrErFrmrGrrrrrrrs  rcrd)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. cstt|||||_dSr )r rr_value)rrgrorrrrr+s zCategoryDataPoint.__init__cCr+)z= The (Y) value for this category data point. )rr rrrro/rzCategoryDataPoint.value)rCrDrErFrrGrorHrrrrr$s  rcs8eZdZdZfddZeddZeddZZS)rzi A data point in an XY chart series. Provides access to the x and y values of the datapoint. cs"tt|||||_||_dSr )r rr_x_y)rrgrZrbrrrrr=s zXyDataPoint.__init__cCr+)z5 The X value for this XY data point. )rr rrrrZBrz XyDataPoint.xcCr+)z5 The Y value for this XY data point. )rr rrrrbIrz XyDataPoint.y) rCrDrErFrrGrZrbrHrrrrr7s  rcrd)rzs A data point in a bubble chart series. Provides access to the x, y, and size values of the datapoint. cs tt|||||||_dSr )r rr_size)rrgrZrbrrrrrrWs zBubbleDataPoint.__init__cCr+)zT The value representing the size of the bubble for this data point. )rr rrrr[rzBubbleDataPoint.bubble_size)rCrDrErFrrGrrHrrrrrQs  r) rF __future__rrcollections.abcrnumbersrpptx.chart.xlsxrrrpptx.chart.xmlwriterr pptx.utilr r rIobjectrerhrsr|rrlrrrrrrrrrrrs0     ofW(t 2!'