.loc is an indexer. It looks for an entry in the index, but the column name is not an index. It is simply a column. The following solutions would work:

df.loc[4, 'rating'] = 100 # Because 4 is in the index, but how do you know?

or:

df.loc[df['name']=='cheerio', 'rating'] = 100 # Find the row by column

or:

df.set_index('name', inplace=True) # Make 'name' the index
df.loc['cheerios', 'rating'] = 100     # Use the indexer

Regardless of the performance, you should be able to do this using loc with boolean indexing:

df = pd.DataFrame([[5, 2], [3, 4]], columns=('a', 'b'))

# modify value in column b where a is 3
df.loc[df.a == 3, 'b'] = 6

df
#   a   b
#0  5   2
#1  3   6

Try this:-

Solution1:-

pandas.concat([df['type'].dropna(), df['caught'].dropna(),df['bowled'].dropna(),df['hit'].dropna()]).reindex_like(df)

If you want that data to become the new column bar, just assign the result to df['dismissal_kind'].

Solution2:-

dataframe["dismissal_kind"] = dataframe["type"].map(str) + dataframe["cought"].map(str)+dataframe["bowled"].map(str)+dataframe["hit"].map(str)

If I understand your question correctly, you can use the isin() method of the dataframe along with masking to make this happen. Let's first create some fake data that looks like yours:

import pandas as pd

df1 = pd.DataFrame({'ISIN': [1, 2, 3, 5]})
df1['Strategy'] = 'Direction'
print(df1)
   ISIN   Strategy
0     1  Direction
1     2  Direction
2     3  Direction
3     5  Direction

df2 = pd.DataFrame({'ISIN':[3, 4, 5, 6]})
print(df2)
   ISIN
0     3
1     4
2     5
3     6

Now we compute a boolean mask using isin() and change these results to 'Extended':

matches = df1['ISIN'].isin(df2['ISIN'])
df1.loc[matches, 'Strategy'] = 'Extended'
print(df1)
   ISIN   Strategy
0     1  Direction
1     2  Direction
2     3   Extended
3     5   Extended

(note that the isin() method checks if each value is in another sequence; similarity to your "ISIN" column name is purely coincidence).