Jul-12-2017, 12:20 AM
Hello,
I have a problem I am trying to solve in Python using Pandas. I have a dictionary of dictionaries that I will eventually be transforming into an sql database. Each of the dictionaries in the dictionary is an excel spreadsheet. Before I can create the database, I must clean up the data. This involves editing the column headers in each dictionary. I need to iterate through every single column header in every single dictionary. If the first character of each column header is non-alpha, i must prepend the column name with "c_". I have iterated through the dictionaries to replace other characters such as ' ' and '%' but I am not sure how to access the first character of each column header and test whether .isalpha() is true or not. If anyone could help, it would be greatly appreciated. Thanks!
P.S.-
so far what I have been doing is this-
I have a problem I am trying to solve in Python using Pandas. I have a dictionary of dictionaries that I will eventually be transforming into an sql database. Each of the dictionaries in the dictionary is an excel spreadsheet. Before I can create the database, I must clean up the data. This involves editing the column headers in each dictionary. I need to iterate through every single column header in every single dictionary. If the first character of each column header is non-alpha, i must prepend the column name with "c_". I have iterated through the dictionaries to replace other characters such as ' ' and '%' but I am not sure how to access the first character of each column header and test whether .isalpha() is true or not. If anyone could help, it would be greatly appreciated. Thanks!
P.S.-
so far what I have been doing is this-
for file in files:
dict_[file].rename(columns = lambda x: x.replace('/', '_'), inplace = True)