I have a .txt file which have following form

Name1 number1 number2 number3 Name2 number4 number5 number6 Name3 number6 number8 number9

I want to import these data as following matrix


namely a 1x9 matrix. When I try this code

new = Part[Import["path\filename.txt", "Table"], Range[1, 3],2 ;; 4]

I get a 3x3 matrix as


due to using the Part command. How can I build a 1x9 matrix where all numbers are placed in one row by importing data from the file or convert the 3x3 matrix obtained from above code to a 1x9 matrix?

| improve this question | | | | |
  • $\begingroup$ Apply Flatten to new. $\endgroup$ – Henrik Schumacher Apr 9 '18 at 9:42
  • $\begingroup$ @Henrik Schumacher Thanks, but this command give me a 9x1 matrix rather than 1x9 one. Do you know a way which produces a 1x9 matrix by importing data from the file directly? $\endgroup$ – Wisdom Apr 9 '18 at 12:53
  • $\begingroup$ Well, the matrix is stored as $3 \times 3$ matrix, so we have to convert it. Fasted way to obtain a $1 \times 9$ matrix might be ArrayReshape[new, {1, Times @@ Dimensions[new]}]. $\endgroup$ – Henrik Schumacher Apr 9 '18 at 13:04
  • $\begingroup$ @Henrik Schumacher That's right! it works perfectly. Thanks. Can you explain about your code a bit? $\endgroup$ – Wisdom Apr 9 '18 at 13:31
  • $\begingroup$ Well, have a look into the documentation of ArrayReshape. Times @@ Dimensions[new] just computes $3 \cdot 3 = 9$ in a way that also works for other matrix sized of new. $\endgroup$ – Henrik Schumacher Apr 9 '18 at 13:33

Just for completeness:

With[{new = Import["path\filename.txt", "Table"]},
  ArrayReshape[new, {1, Times @@ Dimensions[new]}
| improve this answer | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.