pandas 不进口吗? 'NameError:全局名称'pandas'未定义' [英] Is Pandas not importing? 'NameError: global name 'pandas' is not defined'

问题描述

我在这里遇到一些错误，但我认为这是由于熊猫未导入而导致的，因为它是灰色的.如果那是问题，我该如何解决?

I'm getting a few errors here but I think it's due to pandas not importing as it's greyed out. If that is the problem, how would I fix this?

C:\ Anaconda \ python.exe C:/用户/昵称/文档/SKLEARN-STOCKS/stock-mach.py​​追溯(大多数 最近通话结束):文件 "C:/用户/昵称/文档/SKLEARN-STOCKS/stock-mach.py​​"，第38行，在 Key_Stats()文件"C:/Users/nicked/Documents/SKLEARN-STOCKS/stock-mach.py​​"，第12行，在 关键统计 df = pandas.DataFrame(columns = ['Date'，'Unix'，'Ticker'，'DE Ratio'])NameError:未定义全局名称'pandas'

C:\Anaconda\python.exe C:/Users/nickd/Documents/SKLEARN-STOCKS/stock-mach.py Traceback (most recent call last): File "C:/Users/nickd/Documents/SKLEARN-STOCKS/stock-mach.py", line 38, in Key_Stats() File "C:/Users/nickd/Documents/SKLEARN-STOCKS/stock-mach.py", line 12, in Key_Stats df = pandas.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio']) NameError: global name 'pandas' is not defined

以退出代码1完成的过程

Process finished with exit code 1

import pandas as pd
import os
import time
from datetime import datetime

#location of the data files
path = 'C:\Users\nickd\Documents\SKLEARN-STOCKS'
#what specific field do you want to grab and in all files in that directory
def Key_Stats(gather="Total Debt/Equity (mrq) "):
    statspath = path+'/_KeyStats'
    stock_list = [x[0] for x in os.walk(statspath)]
    df = pandas.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio'])

    for each_dir in stock_list[1:5]:
        each_file = os.listdir(each_dir)
        ticker = each_dir.split("//")[1]
        if len(each_file) >0:
            for file in each_file:

                date_stamp = datetime.strptime(file, '%Y%m%d%H%M%S.html')
                #unix_time = time.mktime(date_stamp.timetuple())
                print(date_stamp,unix_time)
                full_file_path = each_file+'/'+file
                #print(full_file_path)
                source = open(full_file_path, 'r').read()
                #print(source)
                try:
                    value = float(source.split(gather+':</td><td class="yfnc_tabledata1">')[1].split('</td>')[0])
                    df = df.append({'Date':date_stamp,'Unix':unix_time,'Ticker':ticker,'DE Ratio':value,}, ignore_index = True)
                except Exception as e:
                    pass

                #print(ticker+":",value)

    save = gather.replace(' ','').replace(')','').replace('(','').replace('/',''+('.csv')
    print(save)
    df.to_csv(save)

                #time.sleep(15)

Key_Stats()

推荐答案

您已将其导入为

import pandas as pd

并致电

#pandas
df = pandas.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio'])

您可以更改

• import pandas as pd到import pandas或
• df = pandas.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio'])到df = pd.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio']).

• import pandas as pd to import pandas or
• df = pandas.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio']) to df = pd.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio']).

错误是由于缺少)

save = gather.replace(' ','').replace(')','').replace('(','').replace('/',''+('.csv'))

这篇关于 pandas 不进口吗? 'NameError:全局名称'pandas'未定义'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！