🌐
Practical Business Python
pbpython.com › categorical-encoding.html
Guide to Encoding Categorical Values in Python - Practical Business Python
For example, the body_style column contains 5 different values. We could choose to encode it like this: ... One trick you can use in pandas is to convert a column to a category, then use those category values for your label encoding:
🌐
KDnuggets
kdnuggets.com › 2023 › 07 › pandas-onehot-encode-data.html
Pandas: How to One-Hot Encode Data - KDnuggets
July 24, 2023 - For the categorical column, we can break it down into multiple columns. For this, we use pandas.get_dummies() method. It takes the following arguments: To better understand the function, let us work on one-hot encoding the dummy dataset.
🌐
TutorialsPoint
tutorialspoint.com › python_pandas › python_pandas_series_str_encode_method.htm
Pandas Series.str.encode() Method
This example demonstrates how to ... pd.DataFrame({ 'COLUMN1': ['', '', ''] }) # Encode strings using 'utf-8' encoding result = df['COLUMN1'].str.encode('utf-8') print("Input DataFrame:") print(df) print("\nDataFrame column after ...
🌐
DataScience Made Simple
datasciencemadesimple.com › home › encode and decode a column of a dataframe in python – pandas
Encode and decode a column of a dataframe in python - pandas - DataScience Made Simple
February 4, 2023 - #create dataframe import pandas as pd d = {'Quarters' : ['quarter1','quarter2','quarter3','quarter4'], 'Revenue':[23400344.567,54363744.678,56789117.456,4132454.987]} df=pd.DataFrame(d) print df ... Lets encode the column named Quarters and save it in the column named Quarters_encoded.
🌐
Pandas
pandas.pydata.org › pandas-docs › version › 0.17.0 › generated › pandas.Series.str.encode.html
pandas.Series.str.encode — pandas 0.17.0 documentation
Encode character string in the Series/Index to some other encoding using indicated encoding. Equivalent to str.encode(). index · modules | next | previous | pandas 0.17.0 documentation » · API Reference » · © Copyright 2008-2014, the pandas development team.
🌐
Medium
medium.com › analytics-vidhya › categorical-encoding-with-pandas-get-dummies-d6f1ae6a3e06
Categorical Encoding with Pandas: get_dummies | by Samuel Kehinde Ayo | Analytics Vidhya | Medium
September 17, 2021 - You can perform hot encoding in just one row with get_dummies. We will using a salary dataset for this demo, download here. The objective of this data science process is to predict the salary of individuals based off other features. We will use Linear Regression for this data, but the data is not ready for the machine learning model. If How do we determine this, we’ll use pandas info() method to have a descriptive look at the data.
🌐
Stack Abuse
stackabuse.com › one-hot-encoding-in-python-with-pandas-and-scikit-learn
One-Hot Encoding in Python with Pandas and Scikit-Learn
July 31, 2021 - We'll be creating a really simple dataset - a list of countries and their ID's: import pandas as pd ids = [11, 22, 33, 44, 55, 66, 77] countries = ['Spain', 'France', 'Spain', 'Germany', 'France'] df = pd.DataFrame(list(zip(ids, countries)), columns=['Ids', 'Countries'])
🌐
Medium
medium.com › @jaberi.mohamedhabib › encoding-categorical-variables-methods-and-techniques-in-pandas-scikit-learn-and-using-dummy-216ae2d5128d
Encoding Categorical Variables: Methods and Techniques in Pandas, Scikit-learn, and Using Dummy Function | by JABERI Mohamed Habib | Medium
September 27, 2024 - This technique works well when ... categories (e.g., colors). import pandas as pd # Sample data data = {'Fruit': ['Apple', 'Banana', 'Orange', 'Apple', 'Banana']} df = pd.DataFrame(data) # Label encoding using pandas' factorize ...
Find elsewhere
🌐
GeeksforGeeks
geeksforgeeks.org › pandas › python-pandas-series-str-encode
Python | Pandas Series.str.encode() - GeeksforGeeks
March 27, 2019 - Example #2 : Use Series.str.encode() function to encode the character strings present in the underlying data of the given series object. Use 'punycode' for encoding. ... # importing pandas as pd import pandas as pd # Creating the Series sr = ...
🌐
Seaborn
deeplearningnerds.com › pandas-encode-ordinal-categorical-features
Pandas - Ordinal Encoding
November 16, 2023 - We have to consider the rank order of the different elements: ... To encode the categorical values, we use the replace() method of Pandas and pass a dictionary with the mapping between categorical and numerical values:
🌐
Pandas
pandas.pydata.org › pandas-docs › version › 0.22 › generated › pandas.Series.str.encode.html
pandas.Series.str.encode — pandas 0.22.0 documentation
Encode character string in the Series/Index using indicated encoding. Equivalent to str.encode(). index · modules | next | previous | pandas 0.22.0 documentation » ·
Top answer
1 of 2
3

You can use this solution implemented to pandas by Series.apply:

from Crypto.Cipher import XOR
import base64

def encrypt(key, plaintext):
  cipher = XOR.new(key)
  return base64.b64encode(cipher.encrypt(plaintext))

def decrypt(key, ciphertext):
  cipher = XOR.new(key)
  return cipher.decrypt(base64.b64decode(ciphertext))

load['Encoded_Column'] = load['F'].apply(lambda x: encrypt('password',x))
load['Decoded_Column'] = (load['Encoded_Column'].apply(lambda x: decrypt('password', x))
                                                .str.decode("utf-8"))
print (load)
   A  B  C  D  E  F Encoded_Column Decoded_Column
0  a  4  7  1  5  a        b'EQ=='              a
1  b  5  8  3  3  a        b'EQ=='              a
2  c  4  9  5  6  a        b'EQ=='              a
3  d  5  4  4  9  b        b'Eg=='              b
4  e  5  2  2  2  b        b'Eg=='              b
5  f  4  0  0  4  b        b'Eg=='              b

Another solution:

import base64
def encode(key, clear):
    enc = []
    for i in range(len(clear)):
        key_c = key[i % len(key)]
        enc_c = chr((ord(clear[i]) + ord(key_c)) % 256)
        enc.append(enc_c)
    return base64.urlsafe_b64encode("".join(enc).encode()).decode()

def decode(key, enc):
    dec = []
    enc = base64.urlsafe_b64decode(enc).decode()
    for i in range(len(enc)):
        key_c = key[i % len(key)]
        dec_c = chr((256 + ord(enc[i]) - ord(key_c)) % 256)
        dec.append(dec_c)
    return "".join(dec)

load['Encoded_Column'] = load['F'].apply(lambda x: encode('password',x))
load['Decoded_Column'] = load['Encoded_Column'].apply(lambda x: decode('password', x))

Or use list comprehension:

load['Encoded_Column'] = [encode('password',x) for x in load['F']]
load['Decoded_Column'] = [decode('password', x) for x in load['Encoded_Column']]

print (load)
   A  B  C  D  E  F Encoded_Column Decoded_Column
0  a  4  7  1  5  a           w5E=              a
1  b  5  8  3  3  a           w5E=              a
2  c  4  9  5  6  a           w5E=              a
3  d  5  4  4  9  b           w5I=              b
4  e  5  2  2  2  b           w5I=              b
5  f  4  0  0  4  b           w5I=              b
2 of 2
0
import pandas as pd
import binascii

load = pd.DataFrame({'A':list('abcdef'),
                   'B':[4,5,4,5,5,4],
                   'C':[7,8,9,4,2,0],
                   'D':[1,3,5,4,2,0],
                   'E':[5,3,6,9,2,4],
                   'F':[binascii.hexlify(x.encode()) for x in 'aaabbb']
                    })

   A  B  C  D  E      F
0  a  4  7  1  5  b'61'
1  b  5  8  3  3  b'61'
2  c  4  9  5  6  b'61'
3  d  5  4  4  9  b'62'
4  e  5  2  2  2  b'62'
5  f  4  0  0  4  b'62'


# decode
binascii.unhexlify(load.loc[1]['F']).decode('utf-8') -->> 'a'

example

print(binascii.hexlify('HelloWorld'.encode())) --> b'48656c6c6f576f726c64'

print(binascii.unhexlify('48656c6c6f576f726c64'.encode())) --> b'HelloWorld'
🌐
Saturn Cloud
saturncloud.io › blog › a-list-of-pandas-readcsv-encoding-options
A List of Pandas readcsv Encoding Options | Saturn Cloud Blog
May 1, 2026 - df = pd.read_csv('example_utf8.csv', encoding='utf-8') print(df) ... Let’s explore several types of encoding method which are supported by Pandas.
🌐
Turing
turing.com › kb › convert-categorical-data-in-pandas-and-scikit-learn
How to Convert Categorical Data in Pandas and Scikit-learn
We generally use one-hot encoding to solve the disadvantage of label encoding. The strategy is to convert each category into a column and assign it a 1 or 0 value. It is a process of creating dummy variables. ... Import pandas as pd #Creating a dataframe Df = pd.Dataframe({‘City’ : [‘Delhi’,’Mumbai’,’Hydrabad’,’Chennai’,’Bangalore’,’Delhi’,’Hydrabad’,’Banglore’,’Delhi’]})
🌐
Linux find Examples
queirozf.com › entries › one-hot-encoding-a-feature-on-a-pandas-dataframe-an-example
One-Hot Encoding a Feature on a Pandas Dataframe: Examples
September 14, 2020 - To produce an actual dummy encoding from your data, use drop_first=True (not that 'australia' is missing from the columns) import pandas as pd # using the same example as above df = pd.DataFrame({'country': ['russia', 'germany', 'australia','korea','germany']}) pd.get_dummies(df["country"],prefix='country',drop_first=True)
🌐
Pandas
pandas.pydata.org › pandas-docs › version › 0.25.1 › reference › api › pandas.Series.str.encode.html
pandas.Series.str.encode — pandas 0.25.1 documentation
Encode character string in the Series/Index using indicated encoding. Equivalent to str.encode(). index · modules | next | previous | pandas 0.25.1 documentation » · API reference » ·