Periods in column names cause page to go blank about dtale HOT 7 CLOSED

from dtale.

@beautah good catch! I've been meaning to fix that. We saw it when using pd.read_json and if you had JSON objects multiple levels deep it concatenates them with periods in the column name. Thus causing the same issue.

Would you be alright with me simply replacing any periods in column names underscores?

from dtale.

I'll let you know when the fix is in. For the time being I think theres a sep argument you can set in pd.json_normalize

from dtale.

I think I am having the same problem with '#' in the column name. I don't think the problem is limited to periods :)

from dtale.

@jboscolo, thanks for the heads up! I’m working on a release which includes the other fix. I’ll include this as well and dig into what other characters pandas doesnt like.

from dtale.

So it looks like pandas has actually solved this issue, but it won't be available until the release of 1.1.0 commit|issue

that being said, I have found a possible work around that will allow me to not remove special characters (https://stackoverflow.com/questions/40045545/pandas-query-string-where-column-name-contains-special-characters)

from dtale.

Fixed this in v.1.7.5. I ended up using this solution which will only work in Python3 and eventually when pandas does a new release it will handle this problem for us. Once that happens I'll make this code be conditional on that version of pandas being used.

from dtale.