,h,tdZddlZddlmZddlmZmZmZddlm Z ddl m Z ddl m Z Gdd e ZGd d e ZGd d eZGddeZGdde ZGddeZGddeZGddeZGddeZGddeZGddeZGddeZGd d!eZGd"d#eZGd$d%eZy)&zChartData and related objects.N)Number)BubbleWorkbookWriterCategoryWorkbookWriterXyWorkbookWriter)ChartXmlWriter)Sequence) lazypropertyceZdZdZdfd ZdZdZdZdZe dZ dZ d Z d Z e d Zd Zd Ze dZdZxZS)_BaseChartDataa Base 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. cFtt| ||_g|_yN)superr __init___number_format_series)self number_format __class__s Q/var/www/html/Resume-Scraper/venv/lib/python3.12/site-packages/pptx/chart/data.pyrz_BaseChartData.__init__s nd,.+ c8|jj|Sr )r __getitem__rindexs rrz_BaseChartData.__getitem__"s||''..rc6|jjSr )r__len__rs rrz_BaseChartData.__len__%s||##%%rc8|jj|Sr )rappendrseriess rrz_BaseChartData.append(s||""6**rcVd}|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+sB  &K$ S% %E &:;;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_format7s"""rcNt|D] \}}||us |cStd)zH Return the integer index of *series* in this sequence. r#) enumerater%)rr!idxss r series_indexz_BaseChartData.series_indexBs5 o FC{  :;;rc8|jj|S)zl Return the Excel worksheet reference to the cell containing the name for *series*. )_workbook_writerseries_name_refr s rr2z_BaseChartData.series_name_refKs $$44V< 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. )CategorySeriesDataradd_data_point)rrTvaluesrrsvalues r add_serieszCategoryChartData.add_seriessA)t]C  K  .E  & &u - .rcRt|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 rrxzCategoryChartData.categories)s&t]E2)|D rcVt}|D]}|j|||_yr )rryr)rcategory_labelsrxrzs rrxzCategoryChartData.categories8s.\ $ +E  # #E * +%rc.|jjSz| The Excel worksheet reference to the categories for this chart (not including the column heading). )r1categories_refrs rrz CategoryChartData.categories_ref?s $$333rc8|jj|S)zv The Excel worksheet reference to the values for *series* (not including the column heading). )r1 values_refr s rrzCategoryChartData.values_refGs $$//77rct|SrA)rrs rr1z"CategoryChartData._workbook_writerNs &d++r)rnN) rFrGrHrIryrrJrxsetterrrr r1rnrrrvrvsl  3     && 448,,rrvceZdZdZfdZdZdZdZedZ edZ edZ d Z ed Z ed Zed Zej d ZxZS)rz A sequence of |data.Category| objects, also having certain hierarchical graph behaviors for support of multi-level (nested) categories. cFtt| g|_d|_yr )rrrrr)rrs rrzCategories.__init__]s  j$(*"rc8|jj|Sr )rr)rr-s rrzCategories.__getitem__bs++C00rc6|jjS)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__es''))rcTt||}|jj||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. )Categoryrrrrzcategorys rryzCategories.add_categoryns)E4( )rc|jdk7ry|dj}tjtjf}t ||ryy)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)depthrzdatetimedate isinstance)rfirst_cat_label date_typess r are_dateszCategories.are_dates}sC ::?q'--mmX%6%67 oz 2rc|jdk7ry|dj}ttjtjf}t ||ryy)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)rrzrrrr)rr numeric_typess r are_numericzCategories.are_numericsG ::? q'--0A0AB o} 5rc|j}|sy|dj}|ddD]}|j|k7std|S)zx The number of hierarchy levels in this category graph. Returns 0 if it contains no categories. rrNcategory depth not uniform)rrr%)rrx first_depthrs rrzCategories.depthsY %%  m)) "12 ?H~~, !=>> ?rcld}|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.indexsI !-- .M=( ]-- -E .?@@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. c34K|]}|jywr r).0cs r z(Categories.leaf_count..s:A1<<:)sumrrs rrzCategories.leaf_counts:)9)9:::rc#:Kfd|D]}|yw)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. c3K|Dcgc]}|jD]}|}}}|r|D]}||Dcgc]}|j|jfc}ycc}}wcc}wwr )sub_categoriesr-rz)rxrscrlevelcatlevelss rrz!Categories.levels..levelsss*4PQq?O?OPbPbPNP#N3 EK 4>>CCGGSYY'> > Q ?sA-A"A-A(A-Nrn)rrrs @rrzCategories.levelss& ?D\ EK scd}|j |jS|jdk7r|S|dj}t|tj tjfry|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. rErrz yyyy\-mm\-dd)rrrzrrr)rGENERALrs rrzCategories.number_formatse    *&& & ::?Nq'-- o x7H7H'I J"rc||_yr r*)rrs rrzCategories.number_formats #r)rFrGrHrIrrrryrJrrrrrrrrrKrLs@rrrWs # 1* ",   A;;&4$$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. cTtt| ||_||_g|_yr )rrr_label_parent_sub_categories)rrzparentrs rrzCategory.__init__s& h&(  !rcTt||}|jj||S)z Return a newly created |data.Category| object having *label* and appended to the end of the sub-category sequence for this category. )rrrrs radd_sub_categoryzCategory.add_sub_category s) E4( ##H-rc|j}|sy|dj}|ddD]}|j|k7std|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.depths_ --$Q'-- &qr* ?H~~, !=>> ?Qrc8|jj|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|jj|}|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!5 2 00 &11 1E 2<==rcT|jsytd|jDS)z The number of leaf category nodes under this category. Returns 1 if this category has no sub-categories. rc34K|]}|jywr r)rrs rrz&Category.leaf_count..@sL88&&Lr)rrrs rrzCategory.leaf_count8s' ##Lt7K7KLLLrc6|j |jSdS)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. r])rrs rrzzCategory.labelBs#kk5t{{=2=rc|j}t|tjtjfrd|j |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_1904rzs rnumeric_str_valzCategory.numeric_str_valKsK  ehmmX->->? @D33I>> >4;;rc|jS)zE The sequence of child categories for this category. )rrs rrzCategory.sub_categoriesWs ###rctj|j}}||j|j|j }|r |dddn |ddd}||z }|j }|s |dkDr|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)rrrrzdate_epochdeltaexcel_day_numbers rrzCategory._excel_date_number^s{ mmT[[eUZZeii8$-T1a 4b"3E  ::-2  ! r)F)rFrGrHrIrrrJrr-rrrzrrrrKrLs@rrrs "   (( >MM>>  $$  rrceZdZdZy) 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)rFrGrHrIrnrrrrrsrrcXeZdZdZddZedZedZedZedZ y) r|z 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. NcBt|||}|j||S)z Return a CategoryDataPoint object newly created with value *value*, an optional *number_format*, and appended to this sequence. )CategoryDataPointr)rrrrXs rr}z!CategorySeriesData.add_data_points$ 'tUMB  Jrc.|jjS)zt The |data.Categories| object that provides access to the category objects for this series. )rPrxrs rrxzCategorySeriesData.categoriess ***rc.|jjSr)rPrrs rrz!CategorySeriesData.categories_refs ...rcT|jDcgc]}|jc}Scc}w)zt A sequence containing the (Y) value of each datapoint in this series, in data point order. )rRrrds rr~zCategorySeriesData.valuess" $(#4#45R555rhc8|jj|S)z} The Excel worksheet reference to the (Y) values for this series (not including the column heading). )rPrrs rrzCategorySeriesData.values_refs **400rr ) rFrGrHrIr}rJrxrr~rrnrrr|r|{s\++//6611rr|c(eZdZdZddZedZy) 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. NcBt|||}|j||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*. ) XySeriesDatarrrTrrss rrzXyChartData.add_seriess$ #4}=  K rct|Sr)rrs rr1zXyChartData._workbook_writers  %%rr )rFrGrHrIrr r1rnrrrrs  &&rrc.eZdZdZddZdZedZy)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. NcBt|||}|j||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*. )BubbleSeriesDatarrs rrzBubbleChartData.add_seriess$ 'tT=A  K rc8|jj|S)zo The Excel worksheet reference for the range containing the bubble sizes for *series*. )r1bubble_sizes_refr s rrz BubbleChartData.bubble_sizes_refs $$55f==rct|Sr)rrs rr1z BubbleChartData._workbook_writers $D))rr )rFrGrHrIrrr r1rnrrrrs% >**rrceZdZdZddZy)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. NcDt||||}|j||S)z| Return an XyDataPoint object newly created with values *x* and *y*, and appended to this sequence. ) XyDataPointr)rrcrkrrXs rr}zXySeriesData.add_data_points& !q!];  Jrr )rFrGrHrIr}rnrrrrs  rrc8eZdZdZddZedZedZy)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. NcFt|||||}|j||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)rrcrksizerrXs rr}zBubbleSeriesData.add_data_point s( %T1a}E  JrcT|jDcgc]}|jc}Scc}w)zw A sequence containing the bubble size for each datapoint in this series, in data point order. )rR bubble_sizerds r bubble_sizeszBubbleSeriesData.bubble_sizess" *.):):;2;;;rhc8|jj|S)zr The Excel worksheet reference for the range containing the bubble sizes for this series. )rPrrs rrz!BubbleSeriesData.bubble_sizes_refs 0066rr )rFrGrHrIr}rJrrrnrrrrs4 <<77rrc2eZdZdZfdZedZxZS)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. c<tt| ||||_yr )rrr_value)rrsrrrs rrzCategoryDataPoint.__init__,s / ]K rc|jS)z= The (Y) value for this category data point. )rrs rrzCategoryDataPoint.value0s {{r)rFrGrHrIrrJrrKrLs@rrr%s! rrcBeZdZdZfdZedZedZxZS)rzi A data point in an XY chart series. Provides access to the x and y values of the datapoint. cJtt| ||||_||_yr )rrr_x_y)rrsrcrkrrs rrzXyDataPoint.__init__>s" k4)+}Erc|jS)z5 The X value for this XY data point. )rrs rrcz XyDataPoint.xC wwrc|jS)z5 The Y value for this XY data point. )rrs rrkz XyDataPoint.yJrr) rFrGrHrIrrJrcrkrKrLs@rrr8s5   rrc2eZdZdZfdZedZxZS)rzs A data point in a bubble chart series. Provides access to the x, y, and size values of the datapoint. c@tt| ||||||_yr )rrr_size)rrsrcrkrrrs rrzBubbleDataPoint.__init__Xs ot-k1aO rc|jS)zT The value representing the size of the bubble for this data point. )r rs rrzBubbleDataPoint.bubble_size\s zzr)rFrGrHrIrrJrrKrLs@rrrRs! rr)rIrnumbersrpptx.chart.xlsxrrrpptx.chart.xmlwriterr pptx.compatr pptx.utilr r rNobjectrprvrrrr|rrrrrrrrnrrrs% 0 "m4Xm4`c3hc3LV0T,T,nd$d$Nq vq h!/1/1d&.&4*k*B?,$7|$7N&.4kr