I have a column in a dataframe containing a sample of the following values: <pre class="prettyprint"><code> Cabin 0 A12 1 C27 2 D56 3 E87 4 G21 5 J64 </code></pre> I would like to create another column containing ONLY the first letter of that column: <pre class="prettyprint"><code> Cabin New_Cabin 0 A12 A 1 C27 C 2 D56 D 3 E87 E 4 G21 G 5 J64 J </code></pre>

Here it is, young <code>Pandas</code> apprentice. <code>df['my_easy_column'] = df.mycol.str[0]</code>

Pandas - GroupBy values based on first letter in the column

I have a column in a dataframe containing a sample of the following values:

I would like to create another column containing ONLY the first letter of that column:

     Cabin   New_Cabin
0    A12     A
1    C27     C
2    D56     D
3    E87     E
4    G21     G
5    J64     J

543

asked Jan 29 '23 18:01

Here it is, young Pandas apprentice.

df['my_easy_column'] = df.mycol.str[0]

181

answered Feb 01 '23 07:02

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!