如何从损坏的数据集中恢复货币信息？
这不是我的领域，所以如果这不在本堆栈的范围内，我深表歉意。
我正在清理（用于个人娱乐并进行可视化以与他人分享）调查数据（下载，9MB），在向公众发布之前经过了一些匿名处理。
其中一个问题是关于每小时付款率并允许自由格式的文本答案。其中一些答案的字符严重损坏，下图显示了两种最常见的情况：
我不想丢弃这些答案，但我不知道如何将它们恢复到有意义的状态。
请求更好的数据转储 - 向相关人员询问，但不太抱有希望。
尝试确定哪些角色以这种方式结束。处理编码总是很麻烦，而且这些看起来不像我以前见过的任何损坏的字符，所以我不知道从哪里开始，也不知道是否有可用的工具来帮助解决这个问题。这甚至可能根本不是有效的字符或货币符号。
尝试将损坏的字符与有效的货币字符进行匹配。鉴于该调查偏向英语国家，我强烈怀疑两者之一可能是欧元字符，另一个可能是英镑字符。但是，我能够通过字符相对于其他答案的数量来可靠地支持这种猜测吗？遗憾的是，未提供地理数据，因此我无法将答案与国家/地区相匹配。
This is so not my area, so I apologize if this is not in scope for this stack.
I am cleaning up (for personal entertainment and making visualization to share with others) survey data (download, 9MB) that went through some manipulations to be anonymized before getting released to the public.
One of the questions was about hourly payment rate and allowed free form text answer. Some of those answers got badly broken characters, two most common cases shown in image below:
I would hate to discard those answers, but I am at loss how to revert them to meaningful state.
Ask for better data dump - poked related people about it, but not too hopeful.
Try to determine which characters ended up this way. Dealing with encodings is always troublesome and these don't look like any broken characters I ever seen before so I have no idea where to start and if there are tools available to help with this. That might not even be a valid characters or currency symbols at all.
Try to match broken characters to valid currency characters. I strongly suspect one of the two might be € character and other might be £ given that survey was slanted towards English-speaking countries. However will I be able to reliably back up such guess by relative quantity of character to other answers? Unfortunately geo data was not provided, so I can't match answers to countries.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
经确认，这是由于调查软件的导出错误造成的，并且字符确实对应于欧元和英镑。
It was confirmed that this was caused by export bug in survey software and characters do correspond to euro and pound.