From the course: Exploring Data Science with .NET using Polyglot Notebooks & ML.NET

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Renaming and removing columns

Renaming and removing columns

- [Instructor] Sometimes you'll need to be able to change the name of a column or remove a column. In this video, we're going to see how we can work with columns in our DataFrames. So, here I have the same data source customers.csv, but I'm loading it up, and I'm calling the info call. This tells me information about each column in my data frame. So, I see the name of the column, the data type that it stores, and then the length of that column, excluding any null values. You'll see these lengths are usually 5,130 rows long, but sometimes you'll see some values that are missing, such as quantity, price, discount and total have three missing values it appears. We'll look more at how to handle missing values in a later video. For now, let's take a look at a more concise way of getting some of that same information on our columns. The data frame object has a columns property, and that columns property will let you look at all the columns that you have in your data frame. You'll see the…

Contents