cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-31036%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EZusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-31036%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EWie%20leite%20ich%20JMP%20auf%20einen%20Dateiordner%20auf%20meinem%20Desktop%2C%20der%20etwa%20400%20CSV-Dateien%20(z.%20B.%20eine%20Datenbank)%20enth%C3%A4lt%2C%20eine%20Reihe%20von%20Spalten%20und%20eine%20%C3%9Cbersichtstabelle%20mit%20einer%20Zeile%20pro%20Datei%20erstellen%3F%20Ich%20kann%20das%20individuell%20machen%2C%20aber%20es%20dauert%20ewig%20und%20ich%20hoffte%2C%20ich%20k%C3%B6nnte%20ein%20Skript%20entwickeln%2C%20um%20es%20zu%20automatisieren.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33888%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33888%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESie%20haben%20Recht%20...%20Danke%20f%C3%BCr%20den%20Fehler%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIch%20habe%20meinen%20urspr%C3%BCnglichen%20Eintrag%20ge%C3%A4ndert%2C%20um%20die%20gefundenen%20Fehler%20zu%20korrigieren%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33875%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33875%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EIch%20denke%2C%20Sie%20wollten%20die%20Zusammenfassungstabellen%20anstelle%20der%20Datentabellen%20anh%C3%A4ngen%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adir%20%3D%20Pick%20Directory()%3B%0Afiles%20%3D%20Files%20In%20Directory(%20dir%20)%3B%0A%0Adt%20%3D%20New%20Table(%20%22concat%22%2C%20New%20Column(%20%22File%22%2C%20character%20)%20)%3B%0AFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20files%20)%2C%20i%2B%2B%2C%20%0A%0A%20If(%20Ends%20With(%20files%5Bi%5D%2C%20%22csv%22%20)%2C%20%2F%2Fjust%20a%20check%20to%20make%20sure%20it's%20a%20csv%0A%20%20%2F%2F%20Open%20the%20file%0A%20%20dt1%20%3D%20Open(%20dir%20%7C%7C%20files%5Bi%5D%20)%3B%0A%20%20%2F%2FGet%20all%20of%20the%20numeric%20columns%20from%20the%20just%20opened%20file%0A%20%20thecolumns%20%3D%20dt1%20%26lt%3B%26lt%3B%20get%20column%20names(%20numeric%20)%3B%0A%20%20%2F%2F%20Create%20an%20output%20table%20of%20one%20row%20that%20contains%20the%20summary%0A%20%20%2F%2F%20As%20many%20stats%20as%20desired%20can%20be%20added%20to%20the%20below%20to%20get%20all%20of%20the%0A%20%20%2F%2F%20ones%20that%20are%20needed%0A%20%20dt1%20%26lt%3B%26lt%3B%20Summary(%20Mean(%20Eval(%20thecolumns%20)%20)%2C%20Freq(%20%22None%22%20)%2C%20Weight(%20%22None%22%20)%2C%20output%20table%20name(%22tmpdt%22))%3B%0A%20%20%2F%2F%20Add%20the%20summary%20table%20to%20the%20summary%20table%0A%20%20dt%20%26lt%3B%26lt%3B%20concatenate(%20Data%20Table(%22tmpdt%22)%2C%20append%20to%20first%20table%20)%3B%0A%20%20%2F%2F%20Since%20what%20is%20wanted%20is%20the%20ID%2C%20not%20the%20file%20name%2C%20and%20the%20ID%20is%0A%20%20%2F%2F%20the%20Sheeet%20name%20in%20the%20Excel%20spreadsheet%2C%20one%20has%20to%20get%20that%20value%0A%20%20%2F%2F%20the%20the%20name%20of%20the%20data%20table%2C%20since%20that%20is%20where%20JMP%2013%20places%20the%0A%20%20%2F%2F%20sheet%20name%0A%20%20dt%3AFile%5BN%20Rows(%20dt%20)%20%5D%20%3D%20dt1%20%26lt%3B%26lt%3B%20Get%20Name%3B%0A%20%20%2F%2F%20Close%20the%20no%20longer%20needed%20raw%20data%20table%0A%20%20Close(%20dt1%2C%20no%20save%20)%3B%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33869%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33869%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHier%20ist%20meine%20Ansicht%20%C3%BCber%20das%20Skript%2C%20das%20ben%C3%B6tigt%20wird.%26nbsp%3B%20Es%20ist%20ziemlich%20einfach%20und%20fasst%20alle%20numerischen%20Spalten%20zusammen%20und%20bringt%20den%20Namen%20der%20Excel-Tabelle%20als%20neue%20Spalte%20mit%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENachfolgend%20werden%20die%20in%20der%20n%C3%A4chsten%20Antwort%20gefundenen%20Probleme%20bearbeitet%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adir%20%3D%20Pick%20Directory()%3B%0Afiles%20%3D%20Files%20In%20Directory(%20dir%20)%3B%0A%0Adt%20%3D%20New%20Table(%20%22concat%22%2C%20New%20Column(%20%22File%22%2C%20character%20)%20)%3B%0AFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20files%20)%2C%20i%2B%2B%2C%20%0A%0A%20If(%20Ends%20With(%20files%5Bi%5D%2C%20%22csv%22%20)%2C%20%2F%2Fjust%20a%20check%20to%20make%20sure%20it's%20a%20csv%0A%20%20%2F%2F%20Open%20the%20file%0A%20%20dt1%20%3D%20Open(%20dir%20%7C%7C%20files%5Bi%5D%2C%20private%20)%3B%0A%20%20%2F%2FGet%20all%20of%20the%20numeric%20columns%20from%20the%20just%20opened%20file%0A%20%20thecolumns%20%3D%20dt1%20%26lt%3B%26lt%3B%20get%20column%20names(%20numeric%20)%3B%0A%20%20%2F%2F%20Create%20an%20output%20table%20of%20one%20row%20that%20contains%20the%20summary%0A%20%20%2F%2F%20As%20many%20stats%20as%20desired%20can%20be%20added%20to%20the%20below%20to%20get%20all%20of%20the%0A%20%20%2F%2F%20ones%20that%20are%20needed%0A%20%20dt2%20%3D%20dt1%20%26lt%3B%26lt%3B%20Summary(%20Mean(%20Eval(%20thecolumns%20)%20)%2C%20Freq(%20%22None%22%20)%2C%20Weight(%20%22None%22%20)%20)%3B%0A%20%20%2F%2F%20Add%20the%20summary%20table%20to%20the%20summary%20table%0A%20%20dt%20%26lt%3B%26lt%3B%20concatenate(%20dt2%2C%20append%20to%20first%20table%20)%3B%0A%20%20%0A%20%20%2F%2F%20Since%20what%20is%20wanted%20is%20the%20ID%2C%20not%20the%20file%20name%2C%20and%20the%20ID%20is%0A%20%20%2F%2F%20the%20Sheeet%20name%20in%20the%20Excel%20spreadsheet%2C%20one%20has%20to%20get%20that%20value%0A%20%20%2F%2F%20the%20the%20name%20of%20the%20data%20table%2C%20since%20that%20is%20where%20JMP%2013%20places%20the%0A%20%20%2F%2F%20sheet%20name%0A%20%20dt%3AFile%5BN%20Rows(%20dt%20)%20%5D%20%3D%20dt1%20%26lt%3B%26lt%3B%20Get%20Name%3B%0A%20%20%2F%2F%20Close%20the%20no%20longer%20needed%20raw%20data%20table%0A%20%20Close(%20dt1%2C%20no%20save%20)%3BClose(%20dt2%2C%20no%20save%20)%3B%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33867%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33867%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHier%20ist%20eine%20Variation%20von%20Vince's%20Antwort%3B%20Dies%20erm%C3%B6glicht%20unterschiedliche%20Spaltennamen%20in%20jeder%20Datei.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3ENames%20Default%20to%20here(1)%3B%0Adir%20%3D%20pick%20directory()%3B%0Afiles%20%3D%20files%20in%20directory(dir)%3B%0A%0A%2F%2Ftable%20to%20hold%20summary%20data%0Adts%20%3D%20New%20Table(%22Summary%22%2C%20New%20Column(%22filename%22%2C%20character))%3B%0A%0A%0Afor(i%3D1%2C%20i%26lt%3B%3Dnitems(files)%2C%20i%2B%2B%2C%20%2F%2Ffor%20each%20filename%0A%0A%20if(endswith(files%5Bi%5D%2C%20%22csv%22)%2C%20%2F%2Fif%20file%20is%20a%20csv%0A%20%0A%20%20%2F%2Fopen%20the%20file%0A%20%20dt1%20%3D%20open(%20dir%7C%7Cfiles%5Bi%5D%2C%20private%20)%3B%0A%20%20%0A%20%20%2F%2Fadd%20a%20row%20to%20the%20summary%20table%0A%20%20dts%20%26lt%3B%26lt%3B%20Add%20Rows(1)%3B%0A%20%20%0A%20%20%2F%2Fsave%20the%20filename%20to%20the%20data%20table%0A%20%20Column(%20dts%2C%20%22filename%22%20)%5Bi%5D%20%3D%20files%5Bi%5D%3B%0A%20%20%0A%20%20%2F%2Fget%20list%20of%20columns%0A%20%20cols%20%3D%20dt1%20%26lt%3B%26lt%3B%20Get%20Column%20Names()%3B%0A%20%20%0A%20%20%2F%2Ffor%20each%20column%0A%20%20for%20(%20c%3D1%2C%20c%20%26lt%3B%3D%20N%20Items(cols)%2C%20c%2B%2B%2C%0A%20%20%0A%20%20%20%2F%2Fadd%20mean%20column%20to%20summary%20table%20if%20it%20isn't%20already%20there%0A%20%20%20if%20(%20Contains(%20dts%20%26lt%3B%26lt%3B%20Get%20Column%20Names()%3B%20%2C%20Parse(%20Char(%20cols%5Bc%5D%20)%20%7C%7C%20%22_mean%22%20)%20)%20%26lt%3B%201%2C%0A%20%20%20%20dts%20%26lt%3B%26lt%3B%20New%20Column(%20Char(%20cols%5Bc%5D%20)%20%7C%7C%20%22_mean%22%20)%3B%0A%20%20%20)%3B%0A%20%20%20%0A%20%20%20%2F%2Ffind%20the%20mean%20and%20write%20it%20to%20summary%20table%0A%20%20%20Column(%20dts%2C%20Char(%20cols%5Bc%5D%20)%20%7C%7C%20%22_mean%22%20)%5Bi%5D%20%3D%20ColMean(%20Column(%20dt1%2C%20cols%5Bc%5D%20)%20)%3B%0A%20%20%20%0A%20%20%20%2F%2Fadd%20max%20column%20to%20summary%20table%20if%20it%20isn't%20already%20there%0A%20%20%20if%20(%20Contains(%20dts%20%26lt%3B%26lt%3B%20Get%20Column%20Names()%3B%20%2C%20Parse(%20Char(%20cols%5Bc%5D%20)%20%7C%7C%20%22_max%22%20)%20)%20%26lt%3B%201%2C%0A%20%20%20%20dts%20%26lt%3B%26lt%3B%20New%20Column(%20Char(%20cols%5Bc%5D%20)%20%7C%7C%20%22_max%22%20)%3B%0A%20%20%20)%3B%0A%20%20%20%0A%20%20%20%2F%2Ffind%20the%20max%20and%20write%20it%20to%20summary%20table%0A%20%20%20Column(%20dts%2C%20Char(%20cols%5Bc%5D%20)%20%7C%7C%20%22_max%22%20)%5Bi%5D%20%3D%20ColMax(%20Column(%20dt1%2C%20cols%5Bc%5D%20)%20)%3B%0A%20%20%20%0A%20%20)%3B%20%2F%2Fend%20loop%20each%20column%0A%20%20%0A%20%20%2F%2Fclose%20file%0A%20%20close(dt1%2C%20no%20save)%3B%0A%20%20%0A%20)%3B%20%2F%2Fend%20check%20for%20csv%0A%20%0A)%3B%20%2F%2Fend%20loop%20for%20each%20file%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33863%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33863%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EZusammengefasst%20wie%3F%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33818%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33818%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESo%20sehen%20die%20Daten%20in%20einer%20CSV-Datei%20aus.%20Der%20Dateiname%20ist%20auch%20die%20Patientenkennung.%20Wie%20kann%20ich%20es%20nach%20Spalten%C3%BCberschriften%20zusammenfassen%20und%20eine%20Tabelle%20der%20zusammengefassten%20Daten%20mit%20der%20Dateikennung%20in%20einer%20Spalte%20erstellen%3F%20Wie%20der%20Dateiname%20aussieht%2C%20sehen%20Sie%20unten%20auf%20dem%20Screenshot.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIch%20k%C3%B6nnte%20alle%20CSVs%20in%20JMP-Dateien%20konvertieren%3F%20Nur%20nicht%20sicher%2C%20ob%20es%20helfen%20w%C3%BCrde.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWei%C3%9F%20jemand%2C%20ob%20das%20Add-In%20f%C3%BCr%20Datentabellen-Tools%20f%C3%BCr%20diesen%20Fall%20funktionieren%20w%C3%BCrde%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33646%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33646%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EK%C3%B6nnen%20Sie%20einen%20Screenshot%20von%20zwei%20falschen%20Tischen%20geben%20und%20wie%20das%20Endergebnis%20aussehen%20soll%3F%20Ich%20kann%20nicht%20herausfinden%2C%20was%20Sie%20fragen.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-33491%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-33491%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EEntschuldigung%20f%C3%BCr%20die%20Versp%C3%A4tung.%20War%20im%20Service%20und%20musste%20sich%20um%20die%20Patienten%20k%C3%BCmmern.%20Kommen%20wir%20jetzt%20zur%C3%BCck.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENein%2C%20sie%20haben%20nicht%20immer%20dieselbe%20Spalte%20(A%2C%20B%2C%20C%20usw.)%2C%20aber%20sie%20haben%20denselben%20Namen.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBrian%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-31057%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-31057%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E(Ignoriere%20diese%20Antwort%3B%20Vince%20hat%20einen%20viel%20besseren%20Ansatz.)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEine%20Variante%20der%20Antwort%20von%20Vince%2C%20wenn%20Sie%20Statistiken%20pro%20Datei%20w%C3%BCnschen.%20%26nbsp%3BIch%20kann%20mir%20auch%20vorstellen%2C%20dass%20die%20Spalten%20konsistent%20sind%20...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Epath%20%3D%20%22%24desktop%2FcsvFiles%2F%22%3B%0Afiles%20%3D%20Files%20In%20Directory(%20path%20)%3B%0A%0Aanswers%20%3D%20New%20Table(%20%22Summary%22%2C%0A%20New%20Column(%20%22N%20Rows%22%2C%20Numeric%2C%20%22Continuous%22%2C%20Format(%20%22Fixed%20Dec%22%2C%2012%2C%200%20)%2C%20Set%20Values(%20%5B%5D%20)%20)%2C%0A%20New%20Column(%20%22Mean(x)%22%2C%20Numeric%2C%20%22Continuous%22%2C%20Format(%20%22Best%22%2C%2012%20)%2C%20Set%20Values(%20%5B%5D%20)%20)%2C%0A%20New%20Column(%20%22Mean(y)%22%2C%20Numeric%2C%20%22Continuous%22%2C%20Format(%20%22Best%22%2C%2012%20)%2C%20Set%20Values(%20%5B%5D%20)%20)%2C%0A%20New%20Column(%20%22Mean(z)%22%2C%20Numeric%2C%20%22Continuous%22%2C%20Format(%20%22Best%22%2C%2012%20)%2C%20Set%20Values(%20%5B%5D%20)%20)%2C%0A%20New%20Column(%20%22sourceFile%22%2C%20character%20)%0A)%3B%0A%0A%0AFor(%20iFile%20%3D%201%2C%20iFile%20%26lt%3B%3D%20N%20Items(%20files%20)%2C%20iFile%20%2B%3D%201%2C%0A%20file%20%3D%20path%20%7C%7C%20files%5BiFile%5D%3B%0A%20dt%20%3D%20Open(%20file%2C%20%22text%22%20)%3B%0A%20dt2%20%3D%20dt%20%26lt%3B%26lt%3B%20Summary(%20Mean(%20%3Ax%20)%2C%20Mean(%20%3Ay%20)%2C%20Mean(%20%3Az%20)%2C%20Freq(%20%22None%22%20)%2C%20Weight(%20%22None%22%20)%20)%3B%0A%20answers%20%26lt%3B%26lt%3B%20addrows(%201%20)%3B%0A%20answers%3AsourceFile%20%3D%20file%20%7C%7C%20%22%20%22%20%7C%7C%20Format(%20Creation%20Date(%20file%20)%2C%20%22m%2Fd%2Fy%20h%3Am%3As%22%20)%3B%0A%20answers%3AN%20Rows%20%3D%20dt2%3AN%20Rows%5B1%5D%3B%0A%20answers%3Aname(%20%22Mean(x)%22%20)%20%3D%20dt2%3Aname(%20%22Mean(x)%22%20)%5B1%5D%3B%0A%20answers%3Aname(%20%22Mean(y)%22%20)%20%3D%20dt2%3Aname(%20%22Mean(y)%22%20)%5B1%5D%3B%0A%20answers%3Aname(%20%22Mean(z)%22%20)%20%3D%20dt2%3Aname(%20%22Mean(z)%22%20)%5B1%5D%3B%0A%20Close(%20dt%2C%20nosave%20)%3B%20%2F%2F%20linked%20table%20closes%20too%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EMeine%20Dateien%20sahen%20so%20aus%3C%2FP%3E%0A%3CP%3Ex%2C%20y%2C%20z%20%3CBR%20%2F%3E%201%2C2%2C3%20%3CBR%20%2F%3E%204%2C5%2C6%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIch%20habe%20das%20Tabellenskript%20aus%20einer%20von%20mir%20erstellten%20Datei%20verwendet%2C%20um%20das%20Zusammenfassungsskript%20zu%20erhalten.%20%26nbsp%3BEs%20gibt%20m%C3%B6glicherweise%20eine%20bessere%20M%C3%B6glichkeit%2C%20die%20Variablen%20zu%20kopieren.%20In%20JMP%2013%20k%C3%B6nnen%20Sie%20die%20Ideen%20verwenden%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FUncharted%2FData-table-subscripting%2Fba-p%2F21013%22%20target%3D%22_self%22%3E%20Hier%20%3C%2FA%3E%20eine%20ganze%20Zeile%20in%20einer%20Anweisung%20zuordnen.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-31051%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Zusammenfassung%20mehrerer%20CSV-Dateien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-31051%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EDeshalb%20mache%20ich%20einige%20Annahmen%20dar%C3%BCber.%20Ich%20k%C3%B6nnte%20weg%20sein%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlle%20CSV-Dateien%20haben%20die%20gleichen%20Spalten.%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESie%20m%C3%B6chten%20f%C3%BCr%20jede%20Datei%20eine%20zusammenfassende%20Zusammenfassung%20(z.%20B.%20Mittelwert)%20f%C3%BCr%20jede%20Spalte%20erstellen.%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20to%20here(1)%3B%0Adir%20%3D%20pick%20directory()%3B%0Afiles%20%3D%20files%20in%20directory(dir)%3B%0A%0Adt%20%3D%20New%20Table(%22concat%22%2C%20New%20Column(%22File%22%2C%20character))%3B%0Afor(i%3D1%2C%20i%26lt%3B%3Dnitems(files)%2C%20i%2B%2B%2C%20%0A%0A%20if(endswith(files%5Bi%5D%2C%20%22csv%22)%2C%20%2F%2Fjust%20a%20check%20to%20make%20sure%20it's%20a%20csv%0A%20%20%2F%2Fbreak()%3B%0A%20%20dt1%20%3D%20open(dir%7C%7Cfiles%5Bi%5D%2C%20private)%3B%0A%20%20dt1%20%26lt%3B%26lt%3B%20New%20Column(%22File%22%2C%20character%2C%20set%20each%20value(files%5Bi%5D))%3B%0A%20%20dt%26lt%3B%3CCONCATENATE%3E%3C%2FCONCATENATE%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
briankwalsh
Level I

Summary of multiple CSV files

How do I direct JMP to a file folder on my desktop that have about 400 CSV files like a database, create a bunch of columns and create a summary table with 1 row per file? I can do this individually, but it takes forever and I was hoping I could develop a script to automate. 

10 REPLIES 10
txnelson
Super User

Re: Summary of multiple CSV files

You are correct.....thanks for catching the mistake

 

I modified my original entry to correct the mistakes you found

Jim

Recommended Articles