/Python/Pandas change multiple column types

Pandas change multiple column types

#Method 1:
df["Delivery Charges"] = df[["Weight", "Package Size", "Delivery Mode"]].apply(
  lambda x : calculate_rate(*x), axis=1)

#Method 2:
df["Delivery Charges"] = df.apply(
  lambda x : calculate_rate(x["Weight"], 
  x["Package Size"], x["Delivery Mode"]), axis=1)

Source: codeforests.medium.com

Pandas change multiple column types

#Two ways to do this
df[['parks', 'playgrounds', 'sports']].apply(lambda x: x.astype('category'))

cols = ['parks', 'playgrounds', 'sports', 'roading']:
public[cols] = public[cols].astype('category')

Source: stackoverflow.com

Set dtype for multiple columns pandas

import pandas as pd

df = pd.DataFrame({'id':['a1', 'a2', 'a3', 'a4'],
  				   'A':['0', '1', '2', '3'],
                   'B':['1', '1', '1', '1'],
                   'C':['0', '1', '1', '0']})

df[['A', 'B', 'C']] = df[['A', 'B', 'C']].apply(pd.to_numeric, axis = 1)

Similar codes

0 vote151 views1 answer
How to interrupt a loop in python
Python
2 votes125 views3 answers
How to get an input into a list python
Python
0 vote143 views1 answer
Np.divide
Python
0 vote117 views1 answer
Get last “column” after .str.split() operation on column in pandas DataFrame
Python
6 votes98 views2 answers
Python loop through folders and subfolders
Python
1 vote136 views1 answer
Python dictionary value as set
Python
10 votes224 views4 answers
Panda python
Python
1 vote132 views2 answers
Urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:997)>
Python
0 vote119 views1 answer
String list into list pandas
Python
8 votes130 views2 answers
Loop through list backwards python
Python