Python3-pandas读写excel

作者: 神木惊蛰 | 来源:发表于2018-05-11 00:48 被阅读6次
    import pandas as pd
    import numpy as np
    
    
    df = pd.read_csv("result.csv")              # csv
    # df = pd.read_excel("sample.xlsx")         # excel
    df.to_excel("sample.xlsx", index=False)     # write data to excel
    print(df.head(10))
    # include row title, read 0-3 row data, sum is 5 row, read 0-1 column data, sum is 2 column
    column = df.ix[:3, :2]                      
    column.to_excel("sample.xlsx", index=False)
    
    def find_need_data(need_list):
        raw_data = pd.read_excel("raw_data.xlsx")
        all_need = []
       need_list = ["vickey", "wu"]
        for n in need_list:
            # find need data
            need = raw_data[raw_data["filed"].str.contains(n)]
            all_need.append(need)
        # write all need data into excel
        pd.concat(all_need).to_excel("sample.xlsx", index=False)
    

    相关文章

      网友评论

        本文标题:Python3-pandas读写excel

        本文链接:https://www.haomeiwen.com/subject/mwjxdftx.html