{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fokazuki.hatenablog.com%2Fentry%2F2016%2F02%2F24%2F003707\" title=\"Python\u3067CSV\u3092\u8aad\u307f\u8fbc\u3093\u3067\u6b20\u640d\u5024\u3092\u7a74\u57cb\u3081\u3059\u308b\u3088 - \u304b\u305a\u304d\u306eBlog@hatena\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"okazuki","version":"1.0","provider_name":"Hatena Blog","categories":["Python"],"title":"Python\u3067CSV\u3092\u8aad\u307f\u8fbc\u3093\u3067\u6b20\u640d\u5024\u3092\u7a74\u57cb\u3081\u3059\u308b\u3088","author_url":"https://blog.hatena.ne.jp/okazuki/","url":"https://okazuki.hatenablog.com/entry/2016/02/24/003707","description":"\u307e\u305a\u306f\u3001Python\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u30893.5\u3092\u5165\u308c\u3088\u3046\u3002 \u305d\u3057\u305f\u3089\u3001DataFrame\u6271\u3046\u305f\u3081\u306epandas\u3092\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002 pip install pandas \u7d42\u308f\u3063\u305f\u3089\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u66f8\u3044\u3066\u5b9f\u884c\uff01 import numpy as np import pandas as pd df = pd.read_csv('input.csv') df = df.fillna(method='ffill') df = df.fillna(method='bfill') df.to_csv('output.csv', index = False)","width":"100%","image_url":null,"provider_url":"https://hatena.blog","blog_title":"\u304b\u305a\u304d\u306eBlog@hatena","height":"190","blog_url":"https://okazuki.hatenablog.com/","published":"2016-02-24 00:37:07","type":"rich"}