2019年8月12日 · The accepted answer caused my column names to wrap around. To show all the column names without wrapping, set both display.max_columns and the display.width: pandas.set_option('display.max_columns', None) pandas.set_option('display.width', 1000)

First create a dictionary from the dataframe column names using regular expressions in order to throw away certain appendixes of column names and then add specific replacements to the dictionary to name core columns as expected later in the receiving database. This is then applied to the dataframe in one go.

This feature is very useful since it allows multiple versions of the same dataframe to be appended 'horizontally' with the 1st level of the column names (in my example instance) distinguishing the instances. Imagine I already have a dataframe like this: a b c bar 0.102885 0.937838 0.907467

Even though the solution that was provided previously is nice, I would also expect something like frame.column_names() to be a function in Pandas, but since it is not, maybe it would be nice to use the following syntax. It somehow preserves the feeling that you are using pandas in a proper way by calling the "tolist" function: frame.columns ...

You can still use the ExcelFile class (and the sheet_names attribute): xl = pd.ExcelFile('foo.xls') xl.sheet_names # see all sheet names xl.parse(sheet_name) # read a specific sheet to DataFrame see docs for parse for more options...

To just get the index column names df.index.names will work for both a single Index or MultiIndex as of the most recent version of pandas. As someone who found this while trying to find the best way to get a list of index names + column names, I would have found this answer useful:

Note: Pandas now (v0.22) has a keyword to specify column names at parsing Excel files. Use: import pandas as pd xl = pd.ExcelFile("Path + filename") df = xl.parse("Sheet 1", header=None, names=['A', 'B', 'C']) If header=None is not set, pd seems to consider the first row as the header and delete it during parsing. If there is indeed a header ...

2017年1月18日 · I normally use dot to access my columns (df.col_name) but just know this trick to access the column names with space by using df[column name with space"]. Thx. – theteddyboy

2017年6月13日 · And therefore I need a solution to create an empty DataFrame with only the column names. For now I have something like this: df = pd.DataFrame(columns=COLUMN_NAMES) # Note that there is no row data inserted. PS: It is important that the column names would still appear in a DataFrame. But when I use it like this I …

2013年3月6日 · I would like to get a list of the names which occur more than once in the column. How do I do that? I tried: funcs_groups = funcs.groupby(funcs.name) funcs_groups[(funcs_groups.count().name>1)] But it doesn't filter out the singleton names.