I am facing the following (incorrect) long panel data format.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str5 webscraperorder2 str10 webscraperorder1 str6 venue_total_ex str1 groupsolo str19 date str68 venue "20887" "1612530277" "" "" "" "Galerie Kronsbein" "20888" "1612530277" "" "" "" "Pinacoteca Giovanni e Marella Agnelli" "20889" "1612530277" "" "" "" "Andipa Gallery" "20890" "1612530277" "" "" "" "Serpentine Galleries" "20891" "1612530277" "" "" "" "The Centre of Attention" "20892" "1612530277" "" "" "Apr 2016 - Sep 2016" "" "20893" "1612530277" "" "" "Nov 2012 - Mar 2013" "" "20894" "1612530277" "" "" "Apr 2009 - May 2009" "" "20895" "1612530277" "" "" "Nov 2006 - Jan 2007" "" "20896" "1612530277" "" "" "May 2002 - Jun 2002" "" "20897" "1612530277" "" "S" "" "" "20898" "1612530277" "" "G" "" "" "20899" "1612530277" "" "S" "" "" "20900" "1612530277" "" "G" "" "" "20901" "1612530277" "" "G" "" "" "20902" "1612530277" "(3)" "" "" "" "20903" "1612530277" "(5)" "" "" "" "20904" "1612530277" "(30)" "" "" "" "20905" "1612530277" "(92)" "" "" "" "20906" "1612530277" "(42)" "" "" "" "20907" "1612530299" "" "" "" "Staatsgalerie Stuttgart" "20908" "1612530299" "" "" "" "Haus der Kunst" "20909" "1612530299" "" "" "" "Museum moderner Kunst Stiftung Ludwig - mumok" "20910" "1612530299" "" "" "" "The Met Breuer" "20911" "1612530299" "" "" "" "Fundação de Serralves" "20912" "1612530299" "" "" "" "LUDWIGGALERIE Schloss Oberhausen" "20913" "1612530299" "" "" "" "Whitney Museum of American Art - America Is Hard to See" "20914" "1612530299" "" "" "" "Deutsche Bank Collection - Artists" "20915" "1612530299" "" "" "" "Walker Art Center" "20916" "1612530299" "" "" "" "Gagosian Gallery - NY 522 West 21st" "20917" "1612530299" "" "" "" "Belvedere" "20918" "1612530299" "" "" "" "UB Art GAllery" "20919" "1612530299" "" "" "" "Collezione Peggy Guggenheim - PGC" "20920" "1612530299" "" "" "" "Louisiana Museum for moderne kunst" "20921" "1612530299" "" "" "" "Halsey Institute of Contemporary Art" "20922" "1612530299" "" "" "" "Hamburger Kunsthalle" "20923" "1612530299" "" "" "" "Moderna Museet - Stockholm" "20924" "1612530299" "" "" "" "John Berggruen Gallery" "20925" "1612530299" "" "" "" "Arca - ex chiesa di San Marco" "20926" "1612530299" "" "" "" "San Francisco Museum of Modern Art - SFMOMA" "20927" "1612530299" "" "" "" "Leslie Sacks Contemporary" "20928" "1612530299" "" "" "" "High Museum of Art" "20929" "1612530299" "" "" "" "Harvard University Art Museums, Arthur M. Sackler Museum" "20930" "1612530299" "" "" "" "Islip Art Museum" "20931" "1612530299" "" "" "" "Carl Solway Gallery" "20932" "1612530299" "" "" "" "Luxembourg & Dayan - London" "20933" "1612530299" "" "" "" "Museum of Fine Arts Houston - MFAH" "20934" "1612530299" "" "" "" "University of Richmond Museums" "20935" "1612530299" "" "" "" "Leo Castelli - 18E 77th" "20936" "1612530299" "" "" "" "Kupferstichkabinett - Staatliche Museen zu Berlin" "20937" "1612530299" "" "" "" "LESLIE SACKS FINE ART" "20938" "1612530299" "" "" "" "Susan Sheehan" "20939" "1612530299" "" "" "" "Kunstmuseum Liechtenstein" "20940" "1612530299" "" "" "" "Institut Valencià d’Art Modern - Centre Julio Gonzalez (IVAM)" "20941" "1612530299" "" "" "" "Whitney Museum of American Art" "20942" "1612530299" "" "" "" "Leo Castelli - 18E 77th" "20943" "1612530299" "" "" "" "National Portrait Gallery - Washington" "20944" "1612530299" "" "" "" "Opelvillen Rüsselsheim" "20945" "1612530299" "" "" "" "Hunter College Leubsdorf Art Gallery" "20946" "1612530299" "" "" "" "Marianne Boesky Gallery - 64th St" "20947" "1612530299" "" "" "" "National Gallery of Art" "20948" "1612530299" "" "" "" "Paula Cooper Gallery" "20949" "1612530299" "" "" "" "Timothy Taylor Gallery" "20950" "1612530299" "" "" "" "Albright Knox Art Gallery" "20951" "1612530299" "" "" "" "Heckscher Museum of Art" "20952" "1612530299" "" "" "" "Solomon R. Guggenheim Museum - SRGM" "20953" "1612530299" "" "" "" "Kunsthalle zu Kiel" "20954" "1612530299" "" "" "" "Collezione Peggy Guggenheim - PGC" "20955" "1612530299" "" "" "" "Saint Louis Art Museum" "20956" "1612530299" "" "" "" "Jane Voorhees Zimmerli Art Museum" "20957" "1612530299" "" "" "" "Leo Castelli - 18E 77th" "20958" "1612530299" "" "" "" "MoMA PS1" "20959" "1612530299" "" "" "" "Gagosian Gallery - NY 522 West 21st" "20960" "1612530299" "" "" "" "The Jewish Museum" "20961" "1612530299" "" "" "" "Heckscher Museum of Art" "20962" "1612530299" "" "" "" "Leslie Sacks Contemporary" "20963" "1612530299" "" "" "" "The Metropolitan Museum of Art" "20964" "1612530299" "" "" "" "Leo Castelli - 18E 77th" "20965" "1612530299" "" "" "" "Kunstmuseum Basel" "20966" "1612530299" "" "" "" "Casey Kaplan" "20967" "1612530299" "" "" "" "Walker Art Center" "20968" "1612530299" "" "" "" "Leo Castelli - 18E 77th" "20969" "1612530299" "" "" "" "National Gallery of Art" "20970" "1612530299" "" "" "" "John Berggruen Gallery" "20971" "1612530299" "" "" "" "National Gallery of Art" "20972" "1612530299" "" "" "" "James Cohan Gallery" "20973" "1612530299" "" "" "" "Yale University Art Gallery" "20974" "1612530299" "" "" "" "Whitney Museum of American Art" "20975" "1612530299" "" "" "" "Leo Castelli - 18E 77th" "20976" "1612530299" "" "" "" "Museum of Fine Arts Houston - MFAH" "20977" "1612530299" "" "" "" "Wexner Center for the Arts" "20978" "1612530299" "" "" "" "Dallas Museum of Art" "20979" "1612530299" "" "" "" "Walker Art Center" "20980" "1612530299" "" "" "" "Joie Lassiter Gallery" "20981" "1612530299" "" "" "" "The Irish Museum of Modern Art - IMMA" "20982" "1612530299" "" "" "" "Gagosian Gallery - 980 Madison Avenue" "20983" "1612530299" "" "" "" "Leo Castelli - 18E 77th" "20984" "1612530299" "" "" "" "Akira Ikeda - Taura (past address)" "20985" "1612530299" "" "" "" "Museum of Fine Arts Houston - MFAH" "20986" "1612530299" "" "" "" "UAMA - University of Arizona Museum of Art & Archive of Visual Arts" end
I.e. all information of the variables on the same raw, grouped by webscraperorder1 and webscraperorder2 (with different lengths).
Code:
* input str5 webscraperorder2 str10 webscraperorder1 str6 venue_total_ex str1 groupsolo str19 date str68 venue "20887" "1612530277" "(3)" "S" "Apr 2016 - Sep 2016" "Galerie Kronsbein" "20888" "1612530277" "(5)" "G" "Nov 2012 - Mar 2013" "Pinacoteca Giovanni e Marella Agnelli" "20889" "1612530277" "(30)" "S" "Apr 2009 - May 2009" "Andipa Gallery" "20890" "1612530277" "(92)" "G" "Nov 2006 - Jan 2007" "Serpentine Galleries" "20891" "1612530277" "(42)" "G" "May 2002 - Jun 2002" "The Centre of Attention"
Kind regards.
0 Response to incorrect panel data structure
Post a Comment