Панды удаляют скобки и запятые из всех ячеек во фрейме данных

У меня проблема, так как я не могу удалить скобки '(' ')' и запятые ',' из моего фрейма данных

Фрейм данных выглядит так

{'Review_content': {0: ('Stood in line 2+ years ago before a reveal of a car was released.  Not because I\'m a super Tesla "fan-boy", but the timing was right for when I\'d be ready for a new car.  I wanted the Model 3 to be an option and hopefully still qualify for the tax credit.  I\'ve been driving the car for more than a month now ... and WOW!  The acceleration and performance are beyond anything that I have experienced before.  The build is great.  Reviews of early release Model 3\'s should some issues but looks like those were corrected.  The single touch screen took a little getting used to, but now find it to be very intuitive.  Overall, a great car.\n\nUpdate after one year of ownership\n---------------------------------------------------\nCan I give the car six stars?  Absolutely love this car.  Everything about it.',),
  1: ('You gotta be able to embrace some change if you want to enjoy this car. Controls, buttons etc, or the lack thereoff, are vastly different from what you might be used to. But basically you can still drive the model 3 like any other car, except it’s whisper quiet and super fast. Runs like on rails, hugs the road like no other. It’s lighter, smaller, and perkier than the model S or X, but still feels rock solid. Has plenty of space for a family of four, and road trips are no problem with a range of 310 miles and the super charger network. Charging at home overnight is so much more convenient than getting gas. Car gets better every month with ‘over the air’ software updates, autopilot keeps evolving. Would not trade the model 3 for any other car in the world! :)',),
  2: ('the three best pieces of machinery in my lifetime is the boeing b52 stratofortress, the apple ip[hone and the tesla model 3!',),
  3: ('My Tesla 3 has the extended battery, premium packages, 19" wheels.    10,000mi review.                                                                                                                                                        What a fun car to drive, very fast, glued to the ground, corners like crazy, This is a sporty car by design, so the ride is firm but very good. The computer screen requires some patience to learn where everything is.....but after a few days, I like it.     The navigation is superb, the sound is quite good, I downloaded the Tesla app on my iPhone, now the car locks/unlocks when getting in the car or leaving, you can set the temperature remotely, the garage door opens within 100\', closes when leaving,  storage is adequate  for this size of a car. It charges automatically after midnight for the lowest electrical rate.  I commute 100 miles so I don\'t have to use superchargers which are slow and pricey.  There is a lot of noise coming through on bad roads, can\'t wait to try some other tires, also significant amount of wind noise. I don\'t buy the Tesla story that since you don\'t have an engine, your hear more noise, simply poor design....I am sure the upcoming electric cars for the big boys will be a lot smoother. Since all the initial Tesla 3 are identical except for the color and tire size, I found a company that sells many options to make it yours (RPMTESLA).\nWell 27000 miles stills works like a charm, no problem to report. I did buy a soundproofing kit, seems to help. I have purchased a set of Vredestein Quatrac 5, they have fantastic reviews\nI have 48000 mi now, no loss in range or speed, a great little car!',),
  4: ('Tesla hit it out of the park with the Model 3 4-door sedan.  As beautiful as the car is on the outside, it is an absolute joy to drive.  Even my wife, a non-techie, loves driving the car.  Virtually all the adjustments to climate control, seats, mirrors, steering wheel and other options are via the very well organized centrally mounted touchscreen.  Though smaller than the Model S sedan with a smallish 75 kWh battery pack, the Model 3 has plenty of leg room for 6 footers.  Tesla says 0-60 in 5.1 seconds.  It is more like 4.6.  Tesla rates the range at 310 miles.  The EPA says 334.  It is a great car on a road trip because of the efficiency with which it uses electricity from the battery pack and the rapidity of charging since there is less energy to replace. You will have trouble buying and eating a hamburger in the time it needs to charge, especially since they modified the charging software to shorten the charging time.\n\nAround town it is very agile in traffic and parks itself, if you like, parallel and perpendicular.  On the road the Traffic Aware cruise control and auto steering are easy to use and work pretty well, though the driver must be alert at all times. \n\nNow with over 10,000 miles under its belt, the car has gotten better via over the air software updates.  The navigation system has been improved.  The car now can navigate itself off an Interstate exit, if you so choose.  The climate control operation is more intuitive and the touchscreen interface has even more flexibility.  All at no added cost.\n\nTesla decided they had to increase the processing power of the main computer in the car and add redundancy for extra reliability.  They changed our our computer board during a one day visit to their local Service Center.  The car now recognizes stop lights and stop signs to help navigate on local roads in addition to interstates.  Actual self driving is a ways off but the driver assistance features come in handy, especially on cross country trips.',)},
 'Review_date': {0: ('06/29/2018 updated 07/02/2019Long Range 4dr Sedan (electric DD)',),
  1: ('04/24/2018 Long Range 4dr Sedan (electric 1DD)',),
  2: ('07/01/2018 Long Range 4dr Sedan (electric 1DD)',),
  3: ('07/08/2018 updated 01/11/2021Long Range 4dr Sedan (electric DD)',),
  4: ('06/08/2018 updated 06/15/2020Long Range 4dr Sedan (electric DD)',)},
 'Review_overall_rating': {0: ('5 out of 5 stars',),
  1: ('5 out of 5 stars',),
  2: ('5 out of 5 stars',),
  3: ('5 out of 5 stars',),
  4: ('5 out of 5 stars',)},
 'Review_title': {0: ('Worth the Wait',),
  1: ('So happy to own and drive the best car ever',),
  2: ('old guy with a new toy',),
  3: ('Fantastic value, still is after 2 years and 34K mi',),
  4: ('Model 3 - still a winner in every respect',)},
 'Reviewer_name': {0: ('Paul',),
  1: ('Namafe',),
  2: ('Don Lockard',),
  3: ('Pierre Monette',),
  4: ('George Hawley',)}}

Я хотел бы, чтобы это выглядело так:

Пример первой записи

Reviewer_name   Review_date     Review_overall_rating   Review_title    Review_content
0   Paul    06/29/2018 updated 07/02/2019Long Range 4dr S...    5 out of 5 stars    Worth the Wait  Stood in line 2+ years ago before a reveal of...

не могли бы вы включить результат df.head().to_dict()? Непонятно, как выглядят ваши данные в минуту.

enke 09.04.2022 17:06

Хорошо, я отредактировал свой пост

Axton 09.04.2022 17:19
Анализ настроения постов в Twitter с помощью Python, Tweepy и Flair
Анализ настроения постов в Twitter с помощью Python, Tweepy и Flair
Анализ настроения текстовых сообщений может быть настолько сложным или простым, насколько вы его сделаете. Как и в любом ML-проекте, вы можете выбрать...
7 лайфхаков для начинающих Python-программистов
7 лайфхаков для начинающих Python-программистов
В этой статье мы расскажем о хитростях и советах по Python, которые должны быть известны разработчику Python.
Установка Apache Cassandra на Mac OS
Установка Apache Cassandra на Mac OS
Это краткое руководство по установке Apache Cassandra.
Сертификатная программа "Кванты Python": Бэктестер ансамблевых методов на основе ООП
Сертификатная программа "Кванты Python": Бэктестер ансамблевых методов на основе ООП
В одном из недавних постов я рассказал о том, как я использую навыки количественных исследований, которые я совершенствую в рамках программы TPQ...
Создание персонального файлового хранилища
Создание персонального файлового хранилища
Вы когда-нибудь хотели поделиться с кем-то файлом, но он содержал конфиденциальную информацию? Многие думают, что электронная почта безопасна, но это...
Создание приборной панели для анализа данных на GCP - часть I
Создание приборной панели для анализа данных на GCP - часть I
Недавно я столкнулся с интересной бизнес-задачей - визуализацией сбоев в цепочке поставок лекарств, которую могут просматривать врачи и...
0
2
33
2
Перейти к ответу Данный вопрос помечен как решенный

Ответы 2

Ответ принят как подходящий

У вас есть кортежи, поэтому один из вариантов — это explode:

out = df.explode(df.columns.tolist()).reindex(['Reviewer_name','Review_date','Review_overall_rating','Review_title','Review_content'], axis=1)

Выход:

    Reviewer_name                                        Review_date  Review_overall_rating                                       Review_title                                     Review_content
0            Paul  06/29/2018 updated 07/02/2019Long Range 4dr Se...       5 out of 5 stars                                     Worth the Wait  Stood in line 2+ years ago before a reveal of ...
1          Namafe     04/24/2018 Long Range 4dr Sedan (electric 1DD)       5 out of 5 stars        So happy to own and drive the best car ever  You gotta be able to embrace some change if yo...
2     Don Lockard     07/01/2018 Long Range 4dr Sedan (electric 1DD)       5 out of 5 stars                             old guy with a new toy  the three best pieces of machinery in my lifet...
3  Pierre Monette  07/08/2018 updated 01/11/2021Long Range 4dr Se...       5 out of 5 stars  Fantastic value, still is after 2 years and 34...  My Tesla 3 has the extended battery, premium p...
4   George Hawley  06/08/2018 updated 06/15/2020Long Range 4dr Se...       5 out of 5 stars          Model 3 - still a winner in every respect  Tesla hit it out of the park with the Model 3 ...

Использование regular expression для замены скобок и запятых:

import pandas as pd
# create df from the dictionary given.
df.apply(lambda x : x.astype(str).str.replace(r"(\(|\)|\,)","", regex = True))

Другие вопросы по теме