{"blog_url":"https://hk29.hatenablog.jp/","author_url":"https://blog.hatena.ne.jp/HK29/","provider_name":"Hatena Blog","author_name":"HK29","height":"190","version":"1.0","blog_title":"Python\u3068VBA\u3067\u4e16\u306e\u4e2d\u3092\u4fbf\u5229\u306b\u3059\u308b","url":"https://hk29.hatenablog.jp/entry/2024/07/28/224847","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/H/HK29/20240728/20240728224556.png","description":"\u672c\u8a18\u4e8b\u3067\u306f\u3001\u4e0b\u56f3\u5de6\u306e\u3088\u3046\u306b\u534a\u89d2\u30ab\u30ca\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u6587\u5b57\u3092\u4e0b\u56f3\u53f3\u306e\u3088\u3046\u306b\u5168\u89d2\u30ab\u30ca\u3078\u5909\u63db\u3059\u308b\u96db\u5f62\u30b3\u30fc\u30c9\u3092\u8f09\u305b\u307e\u3057\u305f\u3002\u30e9\u30a4\u30d6\u30e9\u30ea\u306f\u3001\u300cjaconv\u300d\u3092\u7528\u3044\u307e\u3059\u3002 \u25a0\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u6b21\u306e\u901a\u308a\u3067\u3059\u3002 pip install pandas jaconv \u25a0\u672c\u30d7\u30ed\u30b0\u30e9\u30e0pandas\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u4e0a\u3067\u51e6\u7406\u3059\u308b\u4f8b\u3067\u3059\u3002 import pandas as pd import jaconv # \u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u306e\u4f5c\u6210 data = { 'column1': ['\u534a\u89d2\uff71\uff72\uff73\uff74\uff75', '\u5168\u89d2\u304b\u304d\u304f\u3051\u3053', '\u5168\u89d2\u30b5\u30b7\u30b9\u30bb\u30bd'], 'column2': ['\uff80\uff81\u30c4\uff83\u3068', '\uff85\u306a\uff86\u306b\uff87\u306c\uff88\u306d\uff89\u306e', '\u6b6f\uff8a\u30d2\uff8b\u3075\uff8c\u5c41\uff8d\u4fdd\uff8e']\u2026","published":"2024-07-28 22:48:47","title":"Python \u534a\u89d2\u30ab\u30ca\u3092\u5168\u89d2\u3078\u5909\u63db\u3059\u308b\u300cjaconv\u300d","categories":["Python","\u5909\u63db"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhk29.hatenablog.jp%2Fentry%2F2024%2F07%2F28%2F224847\" title=\"Python \u534a\u89d2\u30ab\u30ca\u3092\u5168\u89d2\u3078\u5909\u63db\u3059\u308b\u300cjaconv\u300d - Python\u3068VBA\u3067\u4e16\u306e\u4e2d\u3092\u4fbf\u5229\u306b\u3059\u308b\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","type":"rich","width":"100%"}