.replace() to replace elements in a Pandas DataFrame
Michio Suginoo
msuginoo at reversalpoint.com
Wed Aug 5 20:12:29 EDT 2020
Hi MRAB,
Sorry, I simply do not understand the intention of your statement.
If .replace() does not do what I want to do: to replace all ' í ' with 'i'
in any form .
Could you advise me other means to do it?
I am still a learner, so I am not knowledgeable. But, I presume, this sort
of needs--to replace parts of string, not an entire string--should be
common.
So, I would presume, there must be some popular way to do it.
If you know, I would appreciate it if you could advise me.
Thanks.
Best
On Wed, Aug 5, 2020 at 8:38 PM MRAB <python at mrabarnett.plus.com> wrote:
> On 2020-08-06 00:06, Michio Suginoo wrote:
> > Hi MRAB,
> >
> > Here is an example:
> > In the original dataframe, I have something like, 'Agronomía'. And I
> > try to transform it to 'Agronomia'.
> > In this case, I try to replace í with i: the former with a Spanish
> > accent, the latter without.
> >
> That's what you want it to do, but what does it _actually_ do? Does it
> _actually_ replace characters in a string, or only match and replace
> entire strings?
>
> If you have a dataframe that contains the strings 'Agronomía' and 'í',
> does it leave 'Agronomía' as-is but replace 'í' with 'i'?
>
> On Wed, Aug 5, 2020 at 8:00 PM MRAB <python at mrabarnett.plus.com
> <mailto:python at mrabarnett.plus.com>> wrote:
> >
> > On 2020-08-05 23:21, Michio Suginoo wrote:
> > > Hi,
> > >
> > > I have trouble with .replace() method in a Pandas DataFrame.
> > > My code is something like this:
> > > correction_dic1 = {'á': 'a', 'í': 'i', 'ú': 'u', 'ó': 'o'}
> > > df = df.replace({'Name' : correction_dic1})
> > > Basically, what I am trying to do here is to replace bowels with
> > Spanish
> > > accent with a plain set of English alphabet in all the entries
> > in the
> > > column called 'Name' in the dataframe, df.
> > >
> > > A strange thing is that it worked perfectly in the same Jupyter
> > notebook
> > > this morning.
> > > But all of a sudden, it started not doing the replacement any more.
> > >
> > > Could anyone tell what could be the problem?
> > >
> > Does that replace characters in strings, or does it replace one
> > string
> > with another, e.g. replace the string 'á' with the string 'a'?
> >
> --
> https://mail.python.org/mailman/listinfo/python-list
>
More information about the Python-list
mailing list