i have 18126 rows × 63 columns but when i do { data.columns } it shows only 49
There are 63 columns but it shows only 49 columns:
Solution
No you have 63 columns. You have multiple times 39 (x7) and 45 (x8)
Try:
>>> len(df.columns)
Remove the prefix number of the question to be not confused:
df.columns = df.columns.str.replace('^\d+\.\s+', '')
Some questions are the same:
'39. How much debt does your household have? [Car loans]',
'39. How much debt does your household have? [Credit Cards]',
'39. How much debt does your household have? [Medical Loans]',
'39. How much debt does your household have? [Mortgages]',
'39. How much debt does your household have? [Payday Loans]',
'39. How much debt does your household have? [Student Loans]',
'39. How much debt does your household have? [Other]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Earnings]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Benefits]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Job security]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Work-life balance]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Professional growth or leadership opportunities]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Workplace/company culture]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Diverse and inclusive work environment]',
'45. Please tell us how satisfied you are with each of these following aspects of your present job [Weekly workload]',
- Create a new column of dictionaries where keys are in another column of lists, and values are found by looking up the keys in another column
- When I create an array of Numpy floats, I get an array of Python floats
- Download an image from image url
- Regarding good coding practices, what is meant by "Useless return at end of function and method"?
- Can the * (unpacking) operator be typed in Python? Or any other variadic args function such that all variadic types are in the result type?
- Why does using the GPU cause a slowdown when performing svd on a double-precision array?
- Python convert mm/dd/yyyy to yyyymmdd using date_format
- Python Webscraping: grequests vs. mult-threaded requests?
- With python sh module, how to preserve combined stdout and stderr?
- How to suppress py.test internal deprecation warnings
- Python: check for data type in list
- Why does inspect identify decorated methods as functions instead of methods in Python?
- Pycharm stopped displaying import errors
- Strange session behaviour with a Flask app on Heroku
- NameError: name 'Frame' is not defined (Python)
- Is there difference between _function and function?
- Does Python have an ordered set?
- Create JSON from CSV and add some header lines with Pandas
- How can I get the date from weeknr and year using strptime
- Python error with request post : 'Connection aborted, timeout('The write operation timed out')
- Why is this monkeypatch in pytest not working?
- Find common characters between two strings
- SSL: CERTIFICATE_VERIFY_FAILED certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')))
- python equivalent to clojure's partition-all?
- python equivalent of java OutputStream?
- Python TimedRotatingFileHandler overwrites logs
- python 2.7 equivalent of built-in method int.from_bytes
- Getting all combinations of key/value pairs in a Python dict
- how to run a django python file from command line
- Why do I get this DBeaver error when importing data from a CSV file?