get column names pandas code example
Example 1: rename column name pandas dataframe
df.rename(columns={"old_col1": "new_col1", "old_col2": "new_col2"})
Example 2: python return column names of pandas dataframe
# Basic syntax:
your_dataframe.columns
# Note, if you want the column names as a list, just do:
list(your_dataframe.columns)
Example 3: pd dataframe get column names
lst = data.columns.values # data is dataframe
Example 4: python select columns names from dataframe
# Import pandas package
import pandas as pd
# making data frame
data = pd.read_csv("nba.csv")
# iterating the columns
for col in data.columns:
print(col)
Example 5: get column names as list
public static List<String> getColumnNames(){
List<String> columnList = new ArrayList<>();
try {
ResultSetMetaData rsMetaData = rs.getMetaData();
for (int colNum = 1; colNum < getColumnCount() ; colNum++) {
columnList.add(rsMetaData.getColumnLabel(colNum));
}
} catch (SQLException e) {
System.out.println("ERROR WHILE GETTING COLUMN NAMES "+ e.getMessage());
}
return columnList;
}
Example 6: pandas dataframe column names
print(data.columns.values)