Unable to configure port in Redis database

Question

I have the following df:

df = pd.DataFrame(data = {'Location': ['ALABAMA', 'Auburn', 'Florence', 'Jacksonville', 'ALASKA', 'Fairbanks'], 'State': ['ALABAMA', np.nan, np.nan, np.nan, 'ALASKA', np.nan]})

       Location    State
0       ALABAMA  ALABAMA
1        Auburn      NaN
2      Florence      NaN
3  Jacksonville      NaN
4        ALASKA   ALASKA
5     Fairbanks      NaN

What I want is to replace the NaN values in the 'State' column with their corresponding state name. In other words, repeat the value in column until a change occurs. This is the desired output:

df_output = pd.DataFrame(data = {'Location': ['ALABAMA', 'Auburn', 'Florence', 'Jacksonville', 'ALASKA', 'Fairbanks'], 'State': ['ALABAMA', 'ALABAMA', 'ALABAMA', 'ALABAMA', 'ALASKA', 'ALASKA']})

       Location    State
0       ALABAMA  ALABAMA
1        Auburn  ALABAMA
2      Florence  ALABAMA
3  Jacksonville  ALABAMA
4        ALASKA   ALASKA
5     Fairbanks   ALASKA

Any idea?

Solution 1

1. 127.0.0.1> AUTH your password
2. OK <--response from redis
3. (7.75s) <--- it's too.
4. 127.0.0.1>ping <--test if you want

5. PONG <--you can receive response from redis

6. you can use AUTH keyword :) and after write your password.

Solution 2

I have had the same problem because I changed the bind IP address in /etc/redis.conf

So I manually set the host ip by using this command:

redis-cli -h 192.168.1.100 -p 7778

Then it started working for me.

Comments

[Fabio Lamanna]

Please provide a Minimal, Complete, and Verifiable example and avoid pictures of data.

[Antonio Serrano]

Sorry, I was in hurry. I already changed it. Thanks for the tip.