[GitHub] michelepetito opened a new issue #3737: Problem with Country Map slice: ['ISO3166'] not in index

[GitBox <gi...@apache.org>]

michelepetito opened a new issue #3737: Problem with Country Map slice:  ['ISO3166'] not in index
URL: https://github.com/apache/incubator-superset/issues/3737
 
 
   
   [superset error.zip](https://github.com/apache/incubator-superset/files/1424257/superset.error.zip)
   
   - [x ] I have checked the superset logs for python stacktraces and included it here as text if any
   - [ ] I have reproduced the issue with at least the latest released version of superset
   - [x ] I have checked the issue tracker for the same issue and I haven't found one similar
   
   
   ### Superset version
   0.19.1
   
   ### Expected results
   The country map. 
   
   ### Actual results
   ```
   "['ISO3166'] not in index"
   ```
   
   
   ```
   Traceback (most recent call last):
     File "/usr/local/lib/python3.6/site-packages/superset/viz.py", line 251, in get_payload
       data = self.get_data(df)
     File "/usr/local/lib/python3.6/site-packages/superset/viz.py", line 1306, in get_data
       ndf = df[cols]
     File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 1958, in __getitem__
       return self._getitem_array(key)
     File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 2002, in _getitem_array
       indexer = self.loc._convert_to_indexer(key, axis=1)
     File "/usr/local/lib/python3.6/site-packages/pandas/core/indexing.py", line 1231, in _convert_to_indexer
       raise KeyError('%s not in index' % objarr[mask])
   KeyError: "['ISO3166'] not in index"
   ```
   
   
   ### Steps to reproduce
   1) Use "redditi.csv" as table source
   2) Create a new coloumn named "ISO3166", type: VARCHAR(10), Groupable, Filterable and with sql expression "trim(concat('IT-', sigla_provincia))".
   3) Create a new slice, with visualization type "country map"
   4) Use as "ISO 3166-1 codes of region/province/department"  the field "ISO3166" and "Redditi Complessivi" (or "Redditi da fabbricato) for metrics.  
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services