I am trying to import data from a file. If I import a CSV file, I get:
{{a,b,c},{e,f,g}}.
For example, two curly brackets.
If importing from a .xlsx file I get an extra curly bracket like:
{{{a,b,c},{e,f,g}}}
Why does this happen?
$\begingroup$
$\endgroup$
0
Add a comment
|
2 Answers
$\begingroup$
$\endgroup$
3
CSV:
Import["file.csv"] imports a CSV file, returning an array.
whereas
XLSX:
Import["file.xlsx"] imports all sheets of an XLSX file, returning the result as a list of arrays.
If the file contains a single sheet, you can eliminate the extra curly braces using the second argument of Import as in @bobthechemist's answer, or simply using Part:
Import["<file.xlsx>"][[1]]
-
$\begingroup$ I need to buy a new keyboard that doesn't have sticky keys; might have beaten you... $\endgroup$ Commented Mar 7, 2015 at 22:49
-
$\begingroup$ @bob, speaking of sticky keys -- only a few of the keys on my laptop are working due to a coffee spill; and my external keyboard happens to be our cat's favorite spot, and hence full of cat hair:) $\endgroup$– kglrCommented Mar 7, 2015 at 22:53
-
$\begingroup$ Thanks both. The learning curve is a killer with Marhematica! But makes sense once explained. $\endgroup$ Commented Mar 8, 2015 at 4:19
$\begingroup$
$\endgroup$
As mentioned in the comments and the documentation, importing from Excel files allows for multiple sheets. Thus, a single-sheet file will have what you refer to as an "extra" pair of curly braces. To eliminate this behavior, use:
Import["<file.xlsx>",{"Data",1}]
The above command will import just the first datasheet.
answered Mar 7, 2015 at 22:47