split column and rename them

Horrible Hoopoe answered on March 17, 2022 Popularity 2/10 Helpfulness 3/10

answer split column and rename them

split column and rename them

Comment

# importing pandas module 
import pandas as pd
   
# reading csv file from url 
data = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv")
  
# dropping null value columns to avoid errors
data.dropna(inplace = True)
  
# new data frame with split value columns
new = data["Name"].str.split(" ", n = 1, expand = True)
  
# making separate first name column from new data frame
data["First Name"]= new[0]
  
# making separate last name column from new data frame
data["Last Name"]= new[1]
  
# Dropping old Name columns
data.drop(columns =["Name"], inplace = True)
  
# df display
data

Popularity 2/10 Helpfulness 3/10 Language python

Source: www.geeksforgeeks.org

Tags: python rename

Link to this answer
Share Copy Link

Contributed on Mar 17 2022

Horrible Hoopoe

0 Answers Avg Quality 2/10

split column and rename them

Contents

More Related Answers

split column and rename them

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.