Question

0 1 2 3 4 Name Sex Age Alex М. 41 Bert М. 42 Carl M 32 Dave M 39 Elly F. 30 Fran F 33 Gwen F 26 Hank 30 Ivan M 53 Jake 32 5 6 7 8 ΣΣ Σ 9 10 Kate F. 47 11 Luke M 34 12 F. 23 Myra Neil 13 M 36 38 14 Omar M E. 31 15 Page 16 Quin 17 Ruth M 29 28 F.
  

I'm having problems with my pandas data frame. When I print my data frame, it is appearing as one long column, instead of putting the data side by side as in the left image. I'm working with python. How do I fix this so that name, sex, and age appear side by side like in image on left?

Answer 1

1 to 18 of 18 entries Filter Age Name Sex 0 M 41 1 42 M M 2 32 39 3 M 4 F 30 5 F 33 6 F 26 import csv with open('data.csv', 'w', newline='') as file: writer = csv.writer(file) writer.writerow(["", "Name", "Sex", "Age"]) writer.writerow([0, "Alex", "M",41]) writer.writerow([1, "Bert", "M",42]) writer.writerow([2, "Carl", "M",32]) writer.writerow([3, "Dave", "M",39]) writer.writerow([4, "Elly", "F",30]) writer.writerow([5, "Fran", "F",33]) writer.writerow( [6, "Gwen", "F",26]) writer.writerow( [7, "Hank", "M",30]) writer.writerow([8, "Ivan", "M",53]) writer.writerow([9, "Jake", "M",32]) writer.writerow([10, "kate", "F",47]) writer.writerow([11, "Luke", "M",34]) writer.writerow([12, "Myra", "F",23]) writer.writerow([13, "Neil", "M",36]) writer.writerow([14, "Omar", "M",38]) writer.writerow([15, "Page", "F",31]) writer.writerow([16, "Quin", "M",29]) writer.writerow([17, "Ruth", "F",28]) 7 M 30 M 53 Alex Bert Carl Dave Elly Fran Gwen Hank Ivan Jake kate Luke Myra Neil Omar Page Quin Ruth M 32 F 8 9 10 11 12 13 47 M 34 F 23 M 36 14 38 M F 15 31 M 29 16 17 Show 25 F 28 per page []

import csv
with open('data.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(["", "Name", "Sex","Age"])
    writer.writerow([0, "Alex", "M",41])
    writer.writerow([1, "Bert", "M",42])
    writer.writerow([2, "Carl", "M",32])
    writer.writerow([3, "Dave", "M",39])
    writer.writerow([4, "Elly", "F",30])
    writer.writerow([5, "Fran", "F",33])
    writer.writerow([6, "Gwen", "F",26])
    writer.writerow([7, "Hank", "M",30])
    writer.writerow([8, "Ivan", "M",53])
    writer.writerow([9, "Jake", "M",32])
    writer.writerow([10, "kate", "F",47])
    writer.writerow([11, "Luke", "M",34])
    writer.writerow([12, "Myra", "F",23])
    writer.writerow([13, "Neil", "M",36])
    writer.writerow([14, "Omar", "M",38])
    writer.writerow([15, "Page", "F",31])
    writer.writerow([16, "Quin", "M",29])
    writer.writerow([17, "Ruth", "F",28])