[METHOD] Make Your Own PAA Site With OpenAI - Complete Tutorial + FREE Python Script

retsepmi said:
Hi, can you check the below and tell me what is happening?

Traceback (most recent call last):
File "C:\xxx\xxx\xxx\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\indexes\base.py", line 3803, in get_loc
return self._engine.get_loc(casted_key)
File "pandas\_libs\index.pyx", line 138, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\index.pyx", line 165, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\hashtable_class_helper.pxi", line 5745, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas\_libs\hashtable_class_helper.pxi", line 5753, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'topic'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "C:\xx\xx\xx\xx\Desktop\AI\aii.py", line 13, in <module>
prompt = f"Please write a detailed article about {row['topic']}. Use this information to write the article: {row['context']}"
File "C:\xx\xx\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\series.py", line 981, in __getitem__
return self._get_value(key)
File "C:\xx\xx\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\series.py", line 1089, in _get_value
loc = self.index.get_loc(label)
File "C:\xx\xx\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\indexes\base.py", line 3805, in get_loc
raise KeyError(key) from err
KeyError: 'topic'
Click to expand...

I’m not sure tbh.

Is your input file as per the instructions? Any funky characters in it?

Maybe someone else can chime in and help you out.
 
Advertise on BHW
retsepmi said:
Hi, can you check the below and tell me what is happening?

Traceback (most recent call last):
File "C:\xxx\xxx\xxx\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\indexes\base.py", line 3803, in get_loc
return self._engine.get_loc(casted_key)
File "pandas\_libs\index.pyx", line 138, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\index.pyx", line 165, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\hashtable_class_helper.pxi", line 5745, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas\_libs\hashtable_class_helper.pxi", line 5753, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'topic'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "C:\xx\xx\xx\xx\Desktop\AI\aii.py", line 13, in <module>
prompt = f"Please write a detailed article about {row['topic']}. Use this information to write the article: {row['context']}"
File "C:\xx\xx\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\series.py", line 981, in __getitem__
return self._get_value(key)
File "C:\xx\xx\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\series.py", line 1089, in _get_value
loc = self.index.get_loc(label)
File "C:\xx\xx\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\core\indexes\base.py", line 3805, in get_loc
raise KeyError(key) from err
KeyError: 'topic'
Click to expand...

You didn't rename first column to: topic

Or it has extra space in it.

Check please.
 
How to install the pandas and openAI modules? I can’t find them on the openAI website
 
Do you check the search volume for each PAA or don't you care?
 
Cool method. Thanks a lot.
What is the promo code for 'Unlocking the Power of AI'?
 
Hey @warriorsam53
I see you are also selling an ebook about sample prompts.
Is it meant to learn about them to come up with our own?
Thanks for the share mate.
 
Frostern said:
How to install the pandas and openAI modules? I can’t find them on the openAI website
Click to expand...

It depends on your set up. You can use pip if you're using the command line. If you're using a GUI tool, then each tool will have a slightly different method. It's best if you google it with info about your specific set up.

leit said:
Do you check the search volume for each PAA or don't you care?
Click to expand...

No, I don't check the volume for any PAA. It doesn't make sense to check the volume any way because it's not something that people type. PAA are created by Google and not generated by user searches.
 
What a day to be alive. I just woke up to read this on my mobile and on my desk in 5 miniutes. Thank you.

/Users/mad/PycharmProjects/pythonProject2/venv/bin/python /Users/mad/PycharmProjects/pythonProject2/main.py
Traceback (most recent call last):
File "/Users/mad/PycharmProjects/pythonProject2/main.py", line 3, in <module>
import sk as sk
File "/Users/mad/PycharmProjects/pythonProject2/venv/lib/python3.9/site-packages/sk/__init__.py", line 4, in <module>
from sklearn import datasets
ModuleNotFoundError: No module named 'sklearn'

an someone help me solve above error. I've installed 'sklearn' module
 
btw was wondering, the output will be in cmd prompt or
zigzagzig said:
You didn't rename first column to: topic

Or it has extra space in it.

Check please.
Click to expand...
thanks it worked!! there was a extra space.
also many thanks to sam for sharing this :)

it worked now, but where does the output.csv gets stored? I run the cmd and without any error it got executed but I cant find the output file
 
retsepmi said:
btw was wondering, the output will be in cmd prompt or
thanks it worked!! there was a extra space.
also many thanks to sam for sharing this :)

it worked now, but where does the output.csv gets stored? I run the cmd and without any error it got executed but I cant find the output file
Click to expand...

It should be in the same folder.
 
I am getting an error like this. How can I get through this? can you help me?
Exception occurred: ParserError
Error tokenizing data. C error: Expected 1 fields in line 3, saw 6
File "C:\Users\Win10\Desktop\text\main.py", line 4, in <module> df = pd.read_csv("input.csv")
Click to expand...
 
jrkral2 said:
I am getting an error like this. How can I get through this? can you help me?
Click to expand...
There‘s a problem with your input file. You‘ve made some sort of mistake while formatting it.
 
warriorsam53 said:
There‘s a problem with your input file. You‘ve made some sort of mistake while formatting it.
Click to expand...
Can you help me? I don't understand Python at all. Is it even possible for you to come to my computer and run it?
 
jrkral2 said:
I am getting an error like this. How can I get through this? can you help me?
Click to expand...
Hey if u r using any IDE you can copy the red error code to google and find answers if you are running it on google colab you can directly search in stackexchange. fixed all my errors just by doing this and now it runs nicely.

Hello @warriorsam53

I just have a simple question.
What if I want to do few more things here.
Like
create SEO title from the topic
then create an article outline for the topic
Then ask to write a detailed blog post using that outline.

Finally only export the seo title and the content (without the outline) to csv.
can I do this just by moderating the prompt or do I need to write some codes. I have 0 knowledge in Python.
 
Last edited:
jrkral2 said:
Can you help me? I don't understand Python at all. Is it even possible for you to come to my computer and run it?
Click to expand...

I think it's best if you learn the basics of Python. Here's a video that covers the basics:

It's 4 hours but you'll have a basic understanding of what's going on.

digi robot said:
I just have a simple question.
What if I want to do few more things here.
Like
create SEO title from the topic
then create an article outline for the topic
Then ask to write a detailed blog post using that outline.

Finally only export the seo title and the content (without the outline) to csv.
can I do this just by moderating the prompt or do I need to write some codes. I have 0 knowledge in Python.
Click to expand...

You can do some of it with prompts. But for some of the functionality you want, you'll need to modify the code.

If you can list all your requirements and specifications, anyone who knows Python can code the script for you. You can probably find someone on the HAF forum, Fiverr or UpWork for 10-15 bucks. You can also learn the basics in a few hours and modify the script however you like.

If you're unwilling to do that, you'll have to run the script multiple times for the different types of output you want and then make your own output file manually by copying and pasting different parts from different output files.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top