gpt4 book ai didi

python - 在 AzureML 中未获得预期输出

转载 作者:行者123 更新时间:2023-12-03 00:32:38 24 4
gpt4 key购买 nike

背景:我正在开发一个项目,旨在使用 Azure ML 中的情绪分析将产品评论分为正面和负面。当我将评论分类到不同的部门时,我陷入了困境。

我基本上是从 csv 文件中读取单词并检查评论(v:句子列表)是否包含这些单词。如果在评论中找到其中一些单词,那么我会记下句子编号并将其插入相应的列表(FinanceList、QualityList、LogisticsList)中。最后,我将列表转换为字符串并将它们推送到数据帧中。

未记录我在 Azure ML 脚本中编写的打印语句的输出。

数据帧中的值始终为 0,但是当我在本地运行代码时,我得到了预期的输出。

第一个图像的描述:数据帧的列显示 0 值。

第二张图片的描述:我突出显示了我在本地获得的预期输出,以进行与 AzureML 中使用的相同审查。

Image 1

Image 2

我已经检查过的事情:

  1. CSV 文件已正确读取。
  2. 评论包含我正在搜索的字词。

我无法理解我哪里出了问题。

'

import csv
import math
import pandas as pd
import numpy as np

def azureml_main( data, ud):

FinanceDept = []
LogisticsDept = []
QualityDept = []
#Reading from the csv files
with open('.\Script Bundle\\quality1.csv', 'rb') as fin:
reader = csv.reader(fin)
QualityDept = list(reader)

with open('.\Script Bundle\\finance1.csv', 'rb') as f:
reader = csv.reader(f)
FinanceDept = list(reader)

with open('.\Script Bundle\\logistics1.csv', 'rb') as f:
reader = csv.reader(f)
LogisticDept = list(reader)

FinanceList = []
LogisticsList = []
QualityList = []

#Initializing the Lists
FinanceList.append(0)
LogisticsList.append(0)
QualityList.append(0)

rev = data['Data']
v = rev[0].split('.')

print FinanceDept

S = 0
for sentence in v:
S = S + 1
z = sentence.split(' ')
for c in z:
c = c.lower()
if c in FinanceDept and S not in FinanceList:
FinanceList.append(S)
if c in LogisticsDept and S not in LogisticsList:
LogisticsList.append(S)
if c in QualityDept and S not in QualityList:
QualityList.append(S)
#Compute User Reputation Score
Upvotes = int(ud['upvotes'].tolist()[0])
Downvotes = int(ud['downvotes'].tolist()[0])
TotalVotes = max(1,Upvotes+Downvotes)

q = data['Score']

print FinanceList

repScore = float(Upvotes)/TotalVotes
repScore = repScore*float( q[0] )
str1 = ','.join(str(e) for e in FinanceList)
str2 = ','.join(str(e) for e in QualityList)
str3 = ','.join(str(e) for e in LogisticsList)

x = ud['id']

#df = pd.DataFrame( [str(repScore), str1 , str2 , str3 ], columns=[Write the columns])
d = {'id': x[0], 'Score': float(repScore),'Logistics':str3,'Finance':str1,'Quality':str2}
df = pd.DataFrame(data=d, index=np.arange(1))
return df,`

最佳答案

@Anuj Shankar,经过同事测试,我们可以从CSV文件中读取数据,得到预期的结果。请引用此经验:

1) 输入数据 - 它有 apple.zip 文件,其中有两个与您相似的 csv 文件,每个 csv 文件包含与公司相关的词袋。

enter image description here2)Python脚本:

# The script MUST contain a function named azureml_main
# which is the entry point for this module.
#
# The entry point function can contain up to two input arguments:
# Param<dataframe1>: a pandas.DataFrame
# Param<dataframe2>: a pandas.DataFrame
import csv
import numpy as np
import pandas as pd

def azureml_main(dataframe1 = None, dataframe2 = None):
# Execution logic goes here
#print('Input pandas.DataFrame #1:\r\n\r\n{0}'.format(dataframe1))

# If a zip file is connected to the third input port is connected,
# it is unzipped under ".\Script Bundle". This directory is added
# to sys.path. Therefore, if your zip file contains a Python file
# mymodule.py you can import it using:
# import mymodule

apple = {}
microsoft = {}
#Reading from the csv files
with open('.\Script Bundle\\apple.csv', 'rb') as f:
reader = csv.reader(f)
apple = list_to_dict(list(reader)[0])

with open('.\Script Bundle\\microsoft.csv', 'rb') as f:
reader = csv.reader(f)
microsoft = list_to_dict(list(reader)[0])

# print('hello world' + ' '.join(apple[0]))
applecount = 0
microsoftcount = 0

input = "i want to buy surface which runs on windows"
splitted_input = input.split(' ')

for word in splitted_input:
if word in apple:
applecount = applecount + 1
if word in microsoft:
microsoftcount = microsoftcount + 1

print("apple bag of words count - " + str(applecount))
print("microsoft bag of words count - " + str(microsoftcount))
mydata = [{'input words': len(splitted_input)}, {'applecount':applecount},
{'microsoftcount':microsoftcount}]
# Return value must be of a sequence of pandas.DataFrame
return pd.DataFrame(mydata),


def list_to_dict(li):
dct = {}
for item in li:
if dct.has_key(item):
dct[item] = dct[item] + 1
else:
dct[item] = 1
return dct

3) 输出 - 如果我考虑一个字符串“我想购买在 Windows 上运行的表面”。它有 2 个与 microsoft 相关的单词和 0 个与 apple 相关的单词,如下面的快照所示。 enter image description here

关于python - 在 AzureML 中未获得预期输出,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/32431471/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com