How to Read .txt in Pandas

try to use sep=r'\s{2,}' as separator – it means use as separator two or more spaces or tabs:

In [28]: df = pd.read_csv(url, sep=r'\s{2,}', engine='python', header=None, names=['ID','Name'])

In [29]: df
Out[29]:
        ID                                                Name
0     A000  Cholera due to Vibrio cholerae 01, biovar cholerae
1     A001     Cholera due to Vibrio cholerae 01, biovar eltor
2     A009                                Cholera, unspecified
3    A0100                          Typhoid fever, unspecified
4    A0101                                  Typhoid meningitis
5    A0102                Typhoid fever with heart involvement
6    A0103                                   Typhoid pneumonia
7    A0104                                   Typhoid arthritis
8    A0105                               Typhoid osteomyelitis
9    A0109              Typhoid fever with other complications
10    A011                                 Paratyphoid fever A
11    A012                                 Paratyphoid fever B
12    A013                                 Paratyphoid fever C
13    A014                      Paratyphoid fever, unspecified
14    A020                                Salmonella enteritis
15    A021                                   Salmonella sepsis
16   A0220         Localized salmonella infection, unspecified
17   A0221                               Salmonella meningitis
18   A0222                                Salmonella pneumonia
19   A0223                                Salmonella arthritis
20   A0224                            Salmonella osteomyelitis
21   A0225                           Salmonella pyelonephritis
22   A0229           Salmonella with other localized infection
23    A028               Other specified salmonella infections
24    A029                   Salmonella infection, unspecified
..     ...                                                 ...
671   B188                       Other chronic viral hepatitis
672   B189                Chronic viral hepatitis, unspecified
673   B190       Unspecified viral hepatitis with hepatic coma
674  B1910  Unspecified viral hepatitis B without hepatic coma
675  B1911     Unspecified viral hepatitis B with hepatic coma
676  B1920  Unspecified viral hepatitis C without hepatic coma
677  B1921     Unspecified viral hepatitis C with hepatic coma
678   B199    Unspecified viral hepatitis without hepatic coma
679    B20          Human immunodeficiency virus [HIV] disease
680   B250                         Cytomegaloviral pneumonitis
681   B251                           Cytomegaloviral hepatitis
682   B252                        Cytomegaloviral pancreatitis
683   B258                      Other cytomegaloviral diseases
684   B259                Cytomegaloviral disease, unspecified
685   B260                                      Mumps orchitis
686   B261                                    Mumps meningitis
687   B262                                  Mumps encephalitis
688   B263                                  Mumps pancreatitis
689  B2681                                     Mumps hepatitis
690  B2682                                   Mumps myocarditis
691  B2683                                     Mumps nephritis
692  B2684                                Mumps polyneuropathy
693  B2685                                     Mumps arthritis
694  B2689                           Other mumps complications
695   B269                          Mumps without complication

[696 rows x 2 columns]

alternatively you can use read_fwf() method

Related Posts:

  1. pandas: merge (join) two data frames on multiple columns
  2. Type error: cannot convert the series to
  3. AttributeError: ‘Series’ object has no attribute ‘reshape’
  4. ImportError: No module named ‘xlrd’
  5. Moving Average Pandas
  6. matplotlib: plot multiple columns of pandas data frame on the bar chart
  7. How to print a specific row of a pandas DataFrame?
  8. How to open a file using the open with statement
  9. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  10. Relative imports – ModuleNotFoundError: No module named x
  11. Writing a pandas DataFrame to CSV file
  12. Best way to convert string to bytes in Python 3?
  13. PermissionError: [Errno 13] Permission denied
  14. What is setup.py?
  15. ValueError: Unknown label type: ‘continuous’
  16. How to deal with SettingWithCopyWarning in Pandas
  17. ImportError: No module named pandas
  18. TypeError: cannot unpack non-iterable NoneType object
  19. Is there a ‘foreach’ function in Python 3?
  20. Python inline if statement
  21. How to copy a dictionary and only edit the copy
  22. How to print like printf in Python3?
  23. Could not find a version that satisfies the requirement tensorflow
  24. Creating an empty Pandas DataFrame, then filling it?
  25. Python Pandas Counting the Occurrences of a Specific value
  26. Count unique values per groups with Pandas
  27. DataFrame constructor not properly called
  28. Convert pandas Series to DataFrame
  29. ImportError: Missing required dependencies [‘numpy’]
  30. TypeError: ‘type’ object is not subscriptable when indexing in to a dictionary
  31. Invalid character in identifier
  32. Pandas: ValueError: cannot convert float NaN to integer
  33. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  34. ‘str’ object has no attribute ‘decode’. Python 3 error?
  35. How to find all the indexes of a recurring item in a list?
  36. ‘DataFrame’ object has no attribute ‘sort’
  37. How do you use subprocess.check_output() in Python?
  38. (Help) TypeError: ‘str’ object cannot be interpreted as an integer
  39. Why KeyError: 0
  40. why should I make a copy of a data frame in pandas
  41. Pandas, merging two dataframes on multiple columns, and multiplying result
  42. Are dictionaries ordered in Python 3.6+?
  43. How to customize a scatter matrix to see all titles?
  44. TypeError: method() takes 1 positional argument but 2 were given
  45. TypeError: write() argument must be str, not bytes (Python 3 vs Python 2 )
  46. How can I get a list shape without using numpy?
  47. How to read a .xlsx file using the pandas Library in iPython?
  48. Why am I getting this syntax error: keyword can’t be an expression
  49. Plot pie chart and table of pandas dataframe
  50. What is dtype(‘O’), in pandas?
  51. ctypes – Beginner
  52. ValueError: ‘object too deep for desired array’
  53. TypeError: ‘encoding’ is an invalid keyword argument for this function
  54. What is the Python 3 equivalent of “python -m SimpleHTTPServer”
  55. What does -> mean in Python function definitions?
  56. Pandas: change data type of Series to String
  57. How do you use subprocess.check_output() in Python?
  58. Normalize data in pandas
  59. Selecting with complex criteria from pandas.DataFrame
  60. Count unique values using pandas groupby
  61. Ignoring NaNs with str.containsv
  62. How to troubleshoot an “AttributeError: __exit__” in multiproccesing in Python?
  63. Count unique values per groups with Pandas [duplicate]
  64. No numeric types to aggregate – change in groupby() behaviour?
  65. Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings
  66. Python map object is not subscriptable
  67. .pyw files in python program
  68. Solution for SpecificationError: nested renamer is not supported while agg() along with groupby()
  69. ValueError: Expected object or value when reading json as pandas dataframe
  70. ImportError: No module named ‘google’
  71. How to check if a column exists in Pandas
  72. Pandas split DataFrame by column value
  73. Get a random sample with replacement
  74. Conda command is not recognized on Windows 10
  75. ImportError: No module named ‘django.core.urlresolvers’
  76. How to do a Sigma in python 3
  77. Python 3: Multiply a vector by a matrix without NumPy
  78. How to fix “Can’t find a default Python” error
  79. TypeError: ‘newline’ is an invalid keyword argument for this function
  80. datetime to string with series in pandas
  81. environment variables PYSPARK_PYTHON and PYSPARK_DRIVER_PYTHON
  82. Find the unique values in a column and then sort them
  83. pandas groupby sort within groups
  84. Python: urllib.error.HTTPError: HTTP Error 404: Not Found
  85. if else function in pandas dataframe
  86. Read data (.dat file) with Pandas
  87. Boolean Series key will be reindexed to match DataFrame index
  88. How to embed image or picture in jupyter notebook, either from a local machine or from a web resource?
  89. Difference between data type ‘datetime64[ns]’ and ‘
  90. Merging two DataFrames
  91. pandas: multiple conditions while indexing data frame – unexpected behavior
  92. What is the correct format to write float value to file in Python
  93. “E: Unable to locate package python3-pip”
  94. Logical operators for Boolean indexing in Pandas
  95. Accessing dict_keys element by index in Python3
  96. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  97. vectorize conditional assignment in pandas dataframe
  98. KeyError: ‘plotly_domain’
  99. TypeError: ‘zip’ object is not subscriptable
  100. Compare two columns using pandas

Leave a Comment