How to assign the category and subcategory values to category and subcategory columns.

This is my code # Import dependencies

import pandas as pd

import numpy as np

pd.set_option('max_colwidth', 400)

# Read the data into a Pandas DataFrame

crowdfunding_info_df = pd.read_excel('Resources/crowdfunding.xlsx',engine='openpyxl')

crowdfunding_info_df.head()

# Get a brief summary of the crowdfunding_info DataFrame.

crowdfunding_info_df.info()

# Get the crowdfunding_info_df columns.

crowdfunding_info_df.columns

the excel file link: https://drive.google.com/drive/folders/1ZSZiZspCGqKbYMcWrNsYxPxALDICYoP7?usp=sharing

Answer rating: 100% (QA)

To assign values to the category and subcategory columns based on certain criteria you can use condi... View the full answer