-2

Hi my code works fine but is there any way to print how many times numbers 1-6 were said into a percentage

I haven't tried anything yet.

import pandas as pd
import random

data = [random.randint(0,6) for _ in range(10)]

df = pd.DataFrame(data)

print(df)

df.to_excel(r'H:\Grade10\Cs\Mir Hussain 12.00.00 3.xlsx', index=False)
Tomerikoo
  • 18,379
  • 16
  • 47
  • 61
HussainMir
  • 33
  • 4

2 Answers2

1

So from your data you could do:

import pandas as pd
import random
from collections import Counter


data = [random.randint(0,6) for _ in range(10)]
total_data = [data]

frequency = Counter(data)
number_elements = len(data)

total_data.append(list((frequency[item] / number_elements)*100 if item != 0 else '' for item in total_data[0]))

df = pd.DataFrame(total_data)

print(df)

df.to_excel(r'H:\Grade10\Cs\Mir Hussain 12.00.00 3.xlsx', index=False)

Item frequency count in Python

Greenonline
  • 1,330
  • 8
  • 23
  • 31
Andrew Ryan
  • 1,489
  • 3
  • 15
  • 21
0
import pandas as pd
import random

data = [random.randint(0,6) for _ in range(10)]

df = pd.DataFrame(data)

df = df.value_counts(normalize=True) # this line makes the percentages

df.to_excel(r'H:\Grade10\Cs\Mir Hussain 12.00.00 3.xlsx', index=False)
L F
  • 548
  • 1
  • 7
  • 22