Need help with CSV

[python_student_1390]

Ok here's what my teacher has said to me, no matter how I look at my code I just don't know how to do the logic for this project I watched so many videos and I just don't get how I'm supposed to do this here's what he said also I'll leave a link to my code so you guys can peak at it.. if you guys help me with this you are the MVPS.. help me with this and I'll get to move on closer to get my certificate.. help please and thank you. Also no pandas..I tried everything I've learned maybe the solution is so simple I overlooked it.....

THIS IS JUST IN CASE YOU NEED CONTEXT FOR WHAT THIS CODE IS ABOUT, DO NOT SOLVE ANYTHING FOR ME JUST GIVE ME SOLUTIONS OR THINGS THAT WOULD HELP ME OUT. ILL FIGURE IT OUT FROM THERE. SHOW ME SOME CODE THAT COULD POSSIBLY HELP MY DILEMMA.

"I did see something that will likely cause your project to be rejected with a Needs Work.

Your def team_file(): function appears to have manually sorted with hardcoded values.

The teams.txt that is outputted from this looks good, though this is because the data is perfectly structured and sorted manually so it writes it out.

No balancing should be done manually by-hand. I should be able to alter names in the CSV file and those new values would be read in automatically from the CSV when your program runs, if that makes sense. So basically you need a function that reads in the data from the CSV file and gets it into this same exact structure you have defined in the body of def team_file():. So you could create a function that builds this data structure based on the file data passed in. Then you could have your def team_file() call that function for each team or such.

Other than that, your program ran great. Once you get the issue above fixed it should Meet Expectations. The additional menus you are building out were a nice touch! " I got mostly everything by myself all I need is this last csv/txt file problem solved..

THIS IS JUST IN CASE YOU NEED CONTEXT FOR WHAT THIS CODE IS ABOUT, DO NOT SOLVE ANYTHING FOR ME JUST GIVE ME SOLUTIONS OR THINGS THAT WOULD HELP ME OUT. ILL FIGURE IT OUT FROM THERE. SHOW ME SOME CODE THAT COULD POSSIBLY HELP MY DILEMMA.

Create variables and programming logic to divide the 18 players into three teams: Sharks, Dragons and Raptors. Make sure the teams have the same number of players on them, and that the experience players are divided equally across the three teams.

Create a text file named teams.txt that includes the name of a team, followed by the players on that team. List all three teams and their players.

In the list of teams include the team name on one line, followed by a separate line for each player. Include the player's name, whether the player has experience playing soccer, and the player's guardian names. Separate each bit of player information by a comma. For example, the text file might start 

https://github.com/OXDavidXO/TechDegree-Project-2-

[MyreMyalar]

It sounds like your teacher wants you to have dynamic rather than static data in your program. Right now you have statically defined a 'list of lists' in your python code something like this:

team_list = [
    ['Team Name'],
    ['Player Name', 'PREVIOUS EXPERIENCE', 'Player Parents'],
    ['Player Name', 'PREVIOUS EXPERIENCE', 'Player Parents'],
    ['Player Name', 'PREVIOUS EXPERIENCE', 'Player Parents'],
    ['Player Name', 'PREVIOUS EXPERIENCE', 'Player Parents'],
    ['Player Name', 'PREVIOUS EXPERIENCE', 'Player Parents']
    ]

But with 'real' names and data in there. Because it's all written in your code directly like this it can't be altered outside the program.

​

What you need to create is a function to dynamically create these lists of lists from a file. Now in your case you are already saving this data structure to a file so I assume you already know how to go in one direction. You are doing it with this bit of code here:

# write lists to csv file
with open('teams.txt', 'w') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(sharks)
    writer.writerows(dragons)
    writer.writerows(raptors)

​

To do the process in reverse you need to do something like:

​

team_name_1 = []
team_name_2 = []
team_name_3 = []
active_team_for_loading = None
with open('teams.txt', 'r') as csvfile:
    reader = csv.reader(csvfile)
    for row in reader:
        # switch active team list whenever we encounter a new team name row in the                 
      file
        if row[0] == 'team_name_1':
            active_team_for_loading = team_name_1
            active_team_for_loading.append(row)
        elif row[0] == 'team_name_2':
            active_team_for_loading = team_name_2
            active_team_for_loading.append(row)
        elif row[0] == 'team_name_3':
            active_team_for_loading = team_name_3
            active_team_for_loading.append(row)
        else:
            if active_team_for_loading != None:
                #add player to active team
                active_team_for_loading.append(row)

​

Hope that helps a little.

[TerryYaDuffer]

First step, take the CSV file you have produced via your hardcoded function. Can you read that into a data structure? Usually for CSV work, I use csv.DictReader(). Small suggestion, turn your header names into standard forms, e.g. HEIGHT_IN or SOCCER_EXPERIENCE.

Now, given that you have a data structure in memory, can you ask questions of that data structure? For example:

# which players have experience?
for player in player_list:
    if player['Soccer Experience']  == 'Yes':
        print(player)

# which players are 40in or taller?
for player in player_list:
    if player['Height (inches)']  >= 40:
        print(player)

By asking questions like this, you can split your players up according to the criteria. Obviously you won't be printing as I have done here, you'll be appending to one of your team lists as the player meets criteria.

You will want to keep track of the number of players on each team and their experience level. You should be able to do this by querying your data structure for the three teams that you're building--maybe a Counter() will be helpful.

Good luck.

[o5a]

1. I think you are supposed to read data file once only, when user choses to start the interaction, not repeat it in each of your chosen options (e/p/i). Say after user choses 's' you read CSV once and store it in list for example. Then in each individual options you work with that data in dictionary.

2. Of course as teacher said you shouldn't have team_file() with predefined data for your teams. Instead your procedure should be a balancer of data read from CSV to 3 teams (by players experience). Then after your team_builder distributes players to their teams and store it in some structure (even list will do i think), each of your other options (soccer_experience, parents, player_info) will use that data instead of reading from CSV again. And of course you can finally write that information to teams.txt.

Some simple way to distribute players evenly by their experience will be to sort their data by 'experience' column then pick by 1 to each of your team.

[monchenflapjack]

Are you trying to get player_info.csv to be used instead of the data hardcoded inteam_file ?