Is there a comprehensive list of all the potential country/region codes (across the global universe) in TR.BGS.GeoTotalRevenue.SegmentCode or an easy way to pull that together with the corresponding name?
@Harlan.tufford Thanks for your question - so please see the following example which actually contains the country names - this uses the Refinitiv Company Fundamentals content set:
df1 = rd.get_data(['VOD.L'], fields=['TR.F.GEOTotRevBizActiv(Period=FY0).SegmGeoIncl', 'TR.F.GEOTotRevBizActiv(Period=FY0).segmentName','TR.F.GEOTotRevBizActiv(Period=FY0)'])df1.sort_values('Standardized Revenue - Geographic Segment', ascending=False, inplace=True)df1.reset_index(inplace=True)df1
Note: the first row is the Total for all segments. I hope this can help.
Kindest regards,