{"published":"2021-09-20 23:29:58","url":"https://hk29.hatenablog.jp/entry/2021/09/20/232958","author_url":"https://blog.hatena.ne.jp/HK29/","author_name":"HK29","blog_title":"Python\u3068VBA\u3067\u4e16\u306e\u4e2d\u3092\u4fbf\u5229\u306b\u3059\u308b","type":"rich","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/H/HK29/20210920/20210920232428.png","categories":["Python","\u62bd\u51fa"],"blog_url":"https://hk29.hatenablog.jp/","provider_name":"Hatena Blog","title":"Python \u8907\u6570\u306e\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u514e\u306b\u89d2\u3001\u3072\u3068\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhk29.hatenablog.jp%2Fentry%2F2021%2F09%2F20%2F232958\" title=\"Python \u8907\u6570\u306e\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u514e\u306b\u89d2\u3001\u3072\u3068\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059 - 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>","width":"100%","version":"1.0","description":"\u4e0b\u56f3\u306e\u3088\u3046\u306b\u3001\u884c\u5217\u6570\u306e\u7570\u306a\u308bcsv\u30d5\u30a1\u30a4\u30eb\u304c\u8907\u6570\u3042\u308b\u3002 \u672c\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u514e\u306b\u89d2\u3001\u4e0b\u56f3\u306e\u3088\u3046\u306b\u3072\u3068\u3064\u306e\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002 \u25a0\u672c\u30d7\u30ed\u30b0\u30e9\u30e0 #!/usr/bin/env python # coding: utf-8 # In[1]: import glob import pandas as pd file_list = glob.glob('*.csv') file_list # In[2]: with open('all.csv', 'w') as f1: for mycsv in file_list: with open(mycsv, 'r') as f2: for r\u2026","provider_url":"https://hatena.blog"}