python如何使用csv文件中的数据运行函数

Question

我有一个在pinterest上执行任务的代码，它可以手动工作，必须在“pin_id=”区域中填写一个数字，当我运行时，将完成重新规划，但是，我想：

1. 在一列csv文件的“pin_id”区域中填写数据
2. 在每个任务之间有一些延迟（5-10秒）
3. 能够限制每次运行时运行的行数， e、 CSV文件可能有数百个数据，我不想一次运行所有数据

[编辑]代码编辑，我最近试过， 代码如下：

 import json
 import random
 import time
 import os
 from csv import reader
 import csv
 import pandas as pd
 from py3pin.Pinterest import Pinterest

 pinterest = Pinterest(email='xxxx',
                  password='xxxx',
                  username='xxxx',
                  cred_root='cred_root')
  def repin(pin_id='', board_id=myboard Id, section_id=None):
  return pinterest.repin(board_id=board_id, pin_id=pin_id, 
  section_id=section_id)

  with open('pin-test.csv','r') as csvfile:  # use with to auto-close file
  for row in csvfile.readlines():  # pin_id
   repin(row)  # board_id and section can use defaults
   time.sleep(random.randint(1,3)) # wait 1-3 seconds

到目前为止，还没有限制要运行的行数的函数

无论如何，编辑的脚本也不起作用

跑步时我会得到这些：

C:\Users\Dav111\Desktop\Python\py3-pinterest-master>z-repin-test.py
Traceback (most recent call last):

File "C:\Users\Dav111\Desktop\Python\py3-pinterest-master\z-repin-test.py", 
line 40, in <module>
repin(row)  # board_id and section can use defaults

File "C:\Users\Dav111\Desktop\Python\py3-pinterest-master\z-repin-test.py", 
line 35, in repin
return pinterest.repin(board_id=board_id, pin_id=pin_id, 
section_id=section_id)

File "C:\Users\Dav111\Desktop\Python\py3-pinterest- 
master\py3pin\Pinterest.py", line 433, in repin
return self.post(url=REPIN_RESOURCE_CREATE, data=data)

File "C:\Users\Dav111\Desktop\Python\py3-pinterest- 
master\py3pin\Pinterest.py", 
line 111, in post
return self.request('POST', url=url, data=data, files=files, 
extra_headers=headers)

File "C:\Users\Dav111\Desktop\Python\py3-pinterest- 
master\py3pin\Pinterest.py", line 103, in request
response.raise_for_status()

File "C:\python\Python38\lib\site-packages\requests\models.py", line 941, in 
raise_for_status
raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 404 Client Error: Not Found for url: 
https://www.pinterest.com/resource/RepinResource/create/

 

感谢你在这方面的帮助

Answer 1

这似乎是直截了当的。只需在迭代数据文件时调用该函数

import random, time

def repin(pin_id='Id number from csv file', board_id=12345, section_id=None):
   return pinterest.repin(board_id=board_id, pin_id=pin_id, section_id=section_id)
   

with open('pin-test.csv','r') as csvfile:  # use with to auto-close file
   for row in csvfile.readlines():  # pin_id
       repin(row)  # board_id and section can use defaults
       time.sleep(random.randint(1,3)) # wait 1-3 seconds