Python Pandas Script Assistance Needed
$30-250 USD
Paid on delivery
I have a small sample file called businessdata.csv.
1) I need Python to go through each record in the [login to view URL] ['Name'] column - and IF the [login to view URL]['Name'] record matches a record from [login to view URL]['BusinessName'] - then I need to add each of the reviews for that business to the [login to view URL], in columns at the end.
I created an [login to view URL] to show an example output what it should look like.
In the output file, just after the column titled 'URL' is where the new columns would go. I named them so you could reference where the data was coming from in the reviews.csv. I did that for the first review, but not reviews 2 through 6, as looking at the first one should explain it sufficiently.
It should add reviews in that format for however many reviews there are.
For the Date Columns, which are review1date, review2date, review3date, review4date, review5date, review6date, etc. - can you format those as MM-YYYY - so the output reads like: "January, 2021".
You will see that in my examples, the businessdata['Name'] only had 3 matches in the reviews['BusinessName'] so it only populated the reviews for those 3 businesses and ignored the others.
One last item, I would like to have a list created, called removerows = []
I would like to remove any rows in [login to view URL] that have an entry in removerows
For testing, you can make removerows = ['Panera Bread', 'Starbucks']
Please read the project before you bid and only bid if you are proficient in Pandas. Please indicate any experience you have with Pandas.
Project ID: #28908583
About the project
Awarded to:
33 freelancers are bidding on average $116 for this job
Hello, I am Python expert and proficient pandas developer with +5 years of experience. I have been using Pandas in processing complex csv files for a long time. Thus, I can do you this easily and professionally. I have More
Hi, Greetings! ✅checked your project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in same kind of projects. If y More
I am a Professional Python Developer with 5+ experience, I can help you with your project, we are expert in ML, Deep Learning and Python Programming Just ping me and we are ready to go
Dear client. I am well experienced in csv processing with python pandas. please ping me to discuss more, I will provide the perfect result. Regards.
Greetings, I have read your description and attached .csv files and 100% sure can do your project. I will be using Visual studio Code for your project using Python. I have vast knowledge of Python libraries like Pandas More
Hello, how are you? Here is a python expert and I am familiar to pandas package. Dataframe management is no problem for me. Please feel free to contact me. Best regards.
Hi! I have read your requirement and attached files very carefully. I understand that you want like a Python programmer. I am glad to bid to you about one of my major skills. For over 8 years, I have developed many Pyt More
Hello sir. As a python/flask/django developer, I'm glad to see your project. If you check my profile, you can see I have much experience of python/flask/django. In fact python is my first language and I have finishe More
I'm a experienced Data Scientist ready to do your work in an efficient way with strong analytical and logical reasoning skills with insatiable interest in Data Science and Big Data Analytics. Data analysis- Data Minin More
I am excel in Pandas dealing with csv. Your description is very clear and so I can start right now and think it shouldn't take long. just need few hours. Thanks!
Hi, I'm an expert in Python programming, Machine Learning, Deep Learning, Natural Language Processing, Data Mining and Image Processing. I've more than Three years experience in this field. My recent projects are "Sh More
hi there , I am a data science instructor and a professional engineer. I am expert in Pandas as I have made many data analysis projects and pandas is always the core of any project. I will deploy the analysis in Jupyt More
Hello sir, I have experience in data analysis using python and pandas library. I can do your project at minimum cost and fastest time. message me to talk about more details and send you a demo. thanks for your time.
Hello, I just have a glance over your venture’s description, it’s totally belongs to me. I feel pleasure to say that I’m an accurate person for you as I have extensive experience in the required field. Precisely I have More