Exercises - column names assignment
Hello,
I have a question regarding an exercise in creating a new df and changing its column names. It has been asked before, but there is no answer as of yet: https://learn.365datascience.com/question/questions-on-the-assignment-for-pandas/
We are asked to create a new DataFrame based on the data in sales_products_data, but with new column names. Then, we should check the column names for both dfs. Why do they change for both the new df, and for the original sales_products_data, if our code only seems to work on the new df?
Code below:
new_column_names = ['SaleID', 'Country', 'OrderMethod', 'Retailer', 'Line',
'Type', 'Product', 'YearOfSales', 'Quarter', 'Revenue', 'Quantity',
'Margin']
method 1)
df = pd.DataFrame(sales_products_data,
columns = new_column_names)
method 2)
df = pd.DataFrame(sales_products_data)
df.columns = new_column_names
Columns Index for both the new df and the original sales_products_data is:
Index(['SaleID', 'Country', 'OrderMethod', 'Retailer', 'Line', 'Type',
'Product', 'YearOfSales', 'Quarter', 'Revenue', 'Quantity', 'Margin'],
dtype='object')
Hello