Я пытаюсь прочитать файл csv с помощью pandas, но когда я показываю свой фрейм данных, я обнаруживаю, что вся строка находится в одном столбце и не разделяется между столбцами
Вот результат:
и вот мой код:
Код: Выделить всё
import pandas as pd
data = pd.read_csv("data/dd.csv",delimiter= ',', engine="python", encoding='ISO-8859-1')
[img]https:/ /i.stack.imgur.com/NkANP.png[/img]
вот мой образец:
Код: Выделить всё
"Report ID, ""Drug Identification Number"", ""Report Type"", ""Brand name"", ""Company Name"", ""Common or Proper name"", Ingredients, Strength(s), ""Packaging size"","" Route of administration"", ""Shortage status"", ""Dosage form(s)"", ""ATC Code"", ""ATC description"", ""Anticipated start date"", ""Actual start date"", ""Estimated end date"", ""Actual end date"", Reason, ""Date Created"", ""Date Updated"", ""Tier 3"" "
"34506,01924303,Shortage,""0.9% SODIUM CHLORIDE INJECTION USP"",""B. BRAUN MEDICAL INC"",""Sodium Chloride"",""SODIUM CHLORIDE"",0.9%,""100mL, 150mL, 250mL, 500mL"",INTRAVENOUS,Resolved,SOLUTION,B05XA,""I.V. SOLUTION ADDITIVES"",2017-12-22,2017-12-22,,2019-01-01,""Disruption of the manufacture of the drug."",2018-01-02,2019-11-06,No "
"28240,01963937,Shortage,""0.9% SODIUM CHLORIDE IRRIGATION USP"",""B. BRAUN MEDICAL INC"",""Sodium Chloride"",""SODIUM CHLORIDE"",0.9%,""500mL, 1000mL, 2000mL, 4000mL"",IRRIGATION,""Actual shortage"",SOLUTION,B05CB,""IRRIGATING SOLUTIONS"",,2017-11-03,,,""Requirements related to complying with good manufacturing practices."",2017-11-06,2019-04-04,No "
"43080,00436208,Shortage,""2% LIDOCAINE HYDROCHLORIDE INJECTION USP"",""HOSPIRA HEALTHCARE CORPORATION"",""LIDOCAINE HYDROCHLORIDE LIFESHIELD"",""LIDOCAINE HYDROCHLORIDE"",20MG,""10 x 5mL"",INTRAVENOUS,Resolved,SOLUTION,C01BB,""ANTIARRHYTHMICS, CLASS I AND III"",2018-04-13,,2018-07-13,2018-07-02,""Disruption of the manufacture of the drug."",2018-03-16,2018-07-03,No "
"51084,00436208,Shortage,""2% LIDOCAINE HYDROCHLORIDE INJECTION USP"",""HOSPIRA HEALTHCARE CORPORATION"",""LIDOCAINE HYDROCHLORIDE ANSYR"",""LIDOCAINE HYDROCHLORIDE"",20MG,""10 x 5mL"",INTRAVENOUS,Resolved,SOLUTION,C01BB,""ANTIARRHYTHMICS, CLASS I AND III"",,2018-06-29,,2018-07-31,""Disruption of the manufacture of the drug."",2018-06-01,2018-08-01,No "
"24792,02141450,Shortage,""20% PROSOL"",""BAXTER CORPORATION"",""20% PROSOL"",""PHENYLALANINE "
"49014,02248489,Shortage,""4% ASTRACAINE DENTAL WITH EPINEPHRINE 1:200,000 (0.005MG/ML)"",""DENTSPLY CANADA LIMITED"",""articaine HCl with epinephrine"",""ARTICAINE HYDROCHLORIDE "
" EPINEPHRINE"",""40MG "
" 0.005MG"",""100 1.8 mL cartridges/box"",BLOCK/INFILTRATION,Resolved,SOLUTION,N01BB,""ANESTHETICS, LOCAL"",2018-05-10,2018-05-10,2018-07-16,2018-06-15,""Disruption of the manufacture of the drug."",2018-05-10,2018-06-19,No "
"27274,02248489,Shortage,""4% ASTRACAINE DENTAL WITH EPINEPHRINE 1:200,000 (0.005MG/ML)"",""DENTSPLY CANADA LIMITED"",""Articaine Hydrochloride 40 mg/mL and Epinephrine Injection 1:200,000"",""ARTICAINE HYDROCHLORIDE "
" EPINEPHRINE"",""40MG "
веб-сайт «Нехватка лекарств в Канаде» >
Подробнее здесь: https://stackoverflow.com/questions/715 ... umn-pandas
