我正在從服務器訪問一些檔案并列印結果，但如何根據列印結果中的名稱獲取重復項。
from datetime import datetime
class EsriApiMaps:
def __init__(self, portal, item_type, query):
self.item_type = item_type
self.query_ = query
self.portal = portal
def query_maps(self):
api_query_result = self.portal.content.search(query=self.query_, item_type=self.item_type)
l = [] # we will store all the services e,g url,id,owner etc
for l in api_query_result:
l_created_time = datetime.fromtimestamp(round(l.created / 1000))
l_modified_time = datetime.fromtimestamp(round(l.modified / 1000))
df = ("Name: " l.title "ID: " l.id ", Owner: " l.owner ", Created: " str(l_created_time) ", Modified: " str(l_modified_time))
print(df)
我試過這個以獲得以下結果，
Name: KL, ID: af57c454, Owner: Scripter, Created: 2019-10-08 12:57:45, Modified: 2019-10-08 12:57:45
Name: KL, ID: dfsjd5s4, Owner: d011, Created: 2020-10-27 21:02:54, Modified: 2020-10-27 21:02:54
Name: TEAM, ID: b8djx8, Owner: j277, Created: 2019-10-08 12:52:54, Modified: 2019-10-08 12:52:54
Name: ALL, ID: b896sfd, Owner: rp10, Created: 2019-10-11 14:51:38, Modified: 2019-10-11 14:51:38
Name: MD, ID: dhx865, Owner: ws07, Created: 2019-10-08 15:17:59, Modified: 2019-10-08 15:17:59
Name: AJKL, ID: dhsa88, Owner: fsdd, Created: 2020-07-23 16:04:20, Modified: 2020-07-23 16:04:20
Name: MD, ID: sd5425, Owner: fsdd, Created: 2021-02-02 11:43:15, Modified: 2021-02-02 11:43:15
Name: MD, ID: vcxb65, Owner: dsff1, Created: 2020-06-17 10:56:36, Modified: 2020-06-17 10:56:36
我試過使用，
names = df.Name.value_counts()
names[names>1]
但我收到此錯誤AttributeError: 'str' object has no attribute 'Name'
如何根據名稱獲取重復項？
預期的結果是
Name: KL, ID: af57c454, Owner: Scripter, Created: 2019-10-08 12:57:45, Modified: 2019-10-08 12:57:45
Name: KL, ID: dfsjd5s4, Owner: d011, Created: 2020-10-27 21:02:54, Modified: 2020-10-27 21:02:54
Name: MD, ID: sd5425, Owner: fsdd, Created: 2021-02-02 11:43:15, Modified: 2021-02-02 11:43:15
Name: MD, ID: vcxb65, Owner: dsff1, Created: 2020-06-17 10:56:36, Modified: 2020-06-17 10:56:36
Name: MD, ID: dhx865, Owner: ws07, Created: 2019-10-08 15:17:59, Modified: 2019-10-08 15:17:59
uj5u.com熱心網友回復：
df 它是一個字串，而不是一個資料框，您應該使用 API 查詢的結果創建一個資料框，然后您可以使用 de 資料框方法。
您可以使用結果創建一個串列，然后用它初始化資料幀。
def query_maps(self):
api_query_result = self.portal.content.search(query=self.query_, item_type=self.item_type)
data = []
for l in api_query_result:
l_created_time = datetime.fromtimestamp(round(l.created / 1000))
l_modified_time = datetime.fromtimestamp(round(l.modified / 1000))
data.append({"Name": l.title, "ID": l.id, "Owner": l.owner, "Created": str(l_created_time), "Modified": str(l_modified_time)})
df = pd.Dataframe(data)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/387645.html
上一篇：如何洗掉熊貓資料框中的分類列？